Senior Data Engineering - DataStage or any ETL Tool, etc
Optum India · Chennai, Tamil Nadu, India
- On site
- Full-time
- $120,000 / year
- Chennai, Tamil Nadu, India
Job highlights
- Design and develop advanced data pipelines and ETL processes.
- Ensure data quality, integrity, and system optimization.
- Collaborate with teams to meet complex data requirements.
- Provide critical production system support and mentorship.
- Utilize DataStage, SQL, Python, Snowflake, and Databricks.
About the role
About Optum
Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health optimization on a global scale. Join us to start Caring. Connecting. Growing together.
Primary Responsibilities
- Design, develop, and maintain advanced data pipelines and ETL processes using niche technologies.
- Collaborate with cross-functional teams to understand complex data requirements and deliver tailored solutions.
- Ensure data quality and integrity by implementing robust data validation and monitoring processes.
- Optimize data systems for performance, scalability, and reliability.
- Develop comprehensive documentation for data engineering processes and systems.
- Handle multiple priorities and deadlines effectively and efficiently while ensuring meeting the desired SLAs.
- Write complex SQL scripts for various business needs.
- Be able to upskill and drive meaningful projects using AI.
- Analyze code, understand its purpose, and modify it to run successfully.
- Independently analyze, solve, and correct issues in real time, providing end-to-end problem resolution.
- Refine and automate regular processes, track issues, and document changes.
- Assist the team with complex query tuning and code refinement.
- Provide support for critical production systems. Willingness to work on Shifts as per business needs.
- Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
- Analyze and investigate new and existing edits, data files, and potential enhancement requests.
- Use pertinent data and facts to identify and solve a range of problems within the area of expertise.
- Serve as 3rd/4th level support for production issues and escalations. Review logs, alerts, and application configurations.
- Investigate non-standard requests and problems, with some assistance from others, using tools for specific applications.
- Act as a liaison between support and product/development.
- Comply with the terms and conditions of the employment contract, company policies and procedures, and any and all directives.
Required Qualifications
- DataStage or any ETL Tool with implementation experience in large sized Data Warehouse.
- Data Warehousing Concepts, Snowflake and Databricks hands-on experience.
- Solid proficiency in SQL and Data Warehouse concepts along with implementation.
- Proficiency in programming languages such as Python etc.
Preferred Qualifications
- Familiarity with cloud platforms (e.g., AWS, Azure, GCP) and data pipeline orchestration tools (e.g. Airflow).
- Proven ability to lead and develop high-performing teams, with excellent communication and interpersonal skills.
- Proven solid analytical and problem-solving abilities, with a focus on delivering actionable insights.
Company Mission
At UnitedHealth Group, our mission is to help people live healthier lives and make the health system work better for everyone. We believe everyone-of every race, gender, sexuality, age, location and income-deserves the opportunity to live their healthiest life. Today, however, there are still far too many barriers to good health which are disproportionately experienced by people of color, historically marginalized groups and those with lower incomes. We are committed to mitigating our impact on the environment and enabling and delivering equitable care that addresses health disparities and improves health outcomes - an enterprise priority reflected in our mission.
Key skills/competency
- Data Engineering
- ETL
- Data Warehousing
- SQL
- Python
- Data Pipeline
- Data Quality
- Problem Solving
- Mentorship
- Production Support
Skills & topics
- Data Engineer
- Senior Data Engineer
- DataStage
- ETL
- Data Warehousing
- SQL
- Python
- Snowflake
- Databricks
- Optum India
How to get hired
- Tailor your resume: Highlight DataStage/ETL, SQL, Python, and Data Warehousing experience for the Senior Data Engineer role at Optum.
- Showcase relevant projects: Detail your experience with data pipeline development, data quality implementation, and production support.
- Prepare for technical questions: Be ready to discuss complex SQL queries, ETL processes, and data warehousing concepts.
- Demonstrate problem-solving: Prepare examples of how you've analyzed and resolved real-time data issues and optimized systems.
- Understand Optum's mission: Align your application and interview responses with Optum's commitment to health optimization and equitable care.
Technical preparation
Master DataStage or equivalent ETL tools.,Practice complex SQL query writing and optimization.,Build projects using Python for data manipulation.,Review Snowflake and Databricks concepts thoroughly.
Behavioral questions
Describe a complex data problem you solved.,How do you ensure data quality and integrity?,Share an experience mentoring junior team members.,How do you handle critical production system issues?
Frequently asked questions
- What are the primary technical skills required for the Senior Data Engineer position at Optum India?
- The Senior Data Engineer role at Optum India requires strong experience with DataStage or any other ETL tool, solid proficiency in SQL and Data Warehousing concepts, and programming skills in languages like Python. Hands-on experience with Snowflake and Databricks is also essential for this position.
- Does Optum India offer opportunities for career growth and development in data engineering?
- Yes, Optum India emphasizes career development opportunities. As a Senior Data Engineer, you will have the chance to upskill, drive meaningful projects, provide technical mentorship, and cross-train with peers, contributing to your professional growth within the organization.
- What is the expected work arrangement for this Senior Data Engineer role at Optum India?
- While the job description mentions willingness to work on shifts as per business needs, the specific work arrangement (on-site, hybrid, or remote) is not explicitly stated. Candidates should inquire about the work arrangement during the application process.
- How does Optum India approach data quality and system optimization for Senior Data Engineers?
- Optum India prioritizes data quality and system performance. Senior Data Engineers are expected to implement robust data validation and monitoring processes, and optimize data systems for performance, scalability, and reliability to ensure data integrity and efficient operations.
- What kind of support and problem-solving responsibilities does a Senior Data Engineer handle at Optum India?
- A Senior Data Engineer at Optum India provides 3rd/4th level support for critical production systems, analyzes and resolves issues in real-time, reviews logs and alerts, and acts as a liaison between support and product/development teams. They are also responsible for investigating non-standard requests and problems.
- Are cloud platform experiences like AWS, Azure, or GCP preferred for the Senior Data Engineer role at Optum India?
- Yes, familiarity with cloud platforms such as AWS, Azure, or GCP, as well as data pipeline orchestration tools like Airflow, is considered a preferred qualification for the Senior Data Engineer position at Optum India.
- How can I best highlight my qualifications for the Senior Data Engineer job at Optum India on my resume?