ETL Data Integration Developer II

About the position

The ETL Data Integration Developer II is responsible for assisting in the design, development, and maintenance of ETL (Extract, Transform, Load) processes and data integration solutions using Informatica PowerCenter/IICS (Informatica Intelligent Cloud Services)/IDMC(Intelligent Data Management Cloud). This position involves working closely with senior developers, technical analysts, and business stakeholders to ensure that the data accurately and efficiently moved and transformed to meet business requirements.

Responsibilities

• Works in integrating data from various source systems into the data warehouse by developing and maintaining workflows, mappings, and sessions using Informatica PowerCenter/IICS (Informatica Intelligent Cloud Services)/IDMC(Intelligent Data Management Cloud) under the guidance of senior ETL Developers/Lead.
• Participates in unit testing and documenting the test results of the codes written at until level.
• Maintains documentation of ETL processes, data flows, and mappings.
• Provides support for ETL processes in production environments.
• Assists in resolving production issues and performing root cause analysis.
• Perform other duties as assigned.

Requirements

• Bachelor's Degree in Computer Science or Related Field
• 4 years of experience in ETL development using Informatica PowerCenter/IICS (Informatica Intelligent Cloud Services)/IDMC(Intelligent Data Management Cloud)
• 2 years of experience in Developing and maintaining workflows, mappings, and sessions.
• 2 years of experience in writing SQL queries.
• 1 year of experience with JIRA tool.
• Basic knowledge of Informatica Power center/IICS (Informatica Intelligent Cloud Services)/IDMC (Intelligent Data Management Cloud).
• Understanding of ETL (Extract, Transform, Load) concepts and methodologies.
• Familiarity with SQL (Structured Query Language) and relational databases.
• Basic understanding of data integration and data quality principles.
• Strong analytical and problem-solving skills.
• Good communication and interpersonal skills.
• Ability to work collaboratively in a team environment.
• Detail-oriented with a focus on quality and accuracy.
• Healthcare domain.

Nice-to-haves

• Master's Degree in Computer Science or Related Field
• Knowledge of AGILE development model.
• Knowledge of cloud based data integration platforms such as AWS, Snowflake.
• Knowledge of Data Warehouse and Data Modeling Concepts.

Benefits

• Paid Time Off (PTO)
• Tuition Reimbursement
• Retirement Plans
• Medical, Dental and Vision
• Wellness Program
• Volunteer Time Off (VTO)