Job Opportunity for B.Tech Graduates at Optum

Insight:

Optum is recruiting an experienced Advisory Services Analyst at its Hyderabad site.

The complete details of this work are as follows:-

Roles and responsibilities:

The ideal candidate must be able to:

• ETL projects and development of ETL processes in enterprise solutions
• Work with multiple data sources, including on-premises systems/applications or cloud-based systems/applications
• Design, develop and maintain database objects (tables, views, stored procedures, etc.) and SQL scripts.
• Develop, test and implement ETL solutions using an agile methodology
• Collaborate with other ETL and/or application developers and business users
• Analysis and investigation
• Provides explanations and interpretations in area of ​​expertise
• Comply with the terms and conditions of the employment contract, company policies and procedures, and all directives (such as, but not limited to, transfer and/or reassignment to different work locations, change of shifts and/or shifts, policies regarding benefits and/or work environment flexibility, alternative work arrangements, and other decisions that may arise due to changes in the business environment ). The Company may adopt, modify or rescind these policies and guidelines in its sole discretion and without any limitation (implied or otherwise) on its ability to do so.

The ideal candidate should also have:

• 5+ years of hands-on experience developing ETL tools (SSIS, Informatica Intelligent Cloud Services)
• Extensive experience in SQL and relational/dimensional databases
• Experience with cloud environments and tools (AWS, S3, Lambdas, Cloud DWs), preferably Azure (Azure Databricks, Blob, Azure Data Factory)
• Experience working with Snowflake in a production environment (beyond POCs)
• Experience with reporting tools (Tableau, QlikView, PowerBI, etc.)
• Experience with Tableau and Power BI
• Experience in Kafka streaming process
• Experience in a cloud infrastructure such as Azure
• Experience in DevOps CI/CD processes. Experience working in Azure DevOps and/or Jenkins
• Good experience with programming languages ​​such as Python, Spark, PySpark, Scala
• Good knowledge of Microsoft Excel
• Knowledge of Cloud SQL database (Azure or AWS)
• Mastery of Agile software development methodology, processes and practices
• Strong, analytical, focused, self-starter with excellent problem solving skills

Eligibility:

• BE/BTech/MBA
• 4-6 years of solid experience as an ETL developer in a data warehouse environment
• 2+ years of work experience
• Strong hands-on experience in building ETL pipelines and data replication
• Experience working with high volume databases with partitioned data, performance and tuning
• Cloud ETL development experience using AWS services/tools, Azure Databricks, Snowflake and/or similar technologies
• Solid knowledge of data warehousing methodologies and concepts, including ETL processes and dimensional data modeling
• Advanced knowledge of databases and SQL queries
• Knowledge of application development cycles and continuous integration/deployment practices
• Good knowledge of SQL, data warehousing principles and practices, and use of ETL tools on-premises and in the cloud.

Join Studycafe to download the file and apply

The link to apply for this job offer is given in the attached PDF.