Senior Informatica IDMC ETL Engineer (Hadoop)

Siri InfoSolutions Inc; Charlotte (NC); On-site; USD 110,000 - 150,000; Full time

Job summary

Siri InfoSolutions Inc. in Charlotte, NC seeks an experienced Informatica IDMC Developer to lead data integration and IDMC migration initiatives. You will design and implement ETL processes, ensure data quality, and work with cross-functional teams to deliver reliable data services.

Requirements include 10+ years of experience, expertise in Oracle and Hadoop ecosystems, strong SQL/PLSQL skills, and exposure to scheduling tools like Autosys.

Qualifications

• Bachelor's or master's degree in computer science or related field.
• Minimum 2 years experience in IDMC migration projects.
• Experience in Agile Methodology.
• Experience with code versioning tools like Bit-Bucket.
• SQL Proficiency: Utilize SQL/PLSQL to extract, transform, and load data.
• Exposure to advanced transformations like data transformations, Parsing JSON/XML messages.
• Experience with HDFS, MapReduce, and Hadoop ecosystems.
• Data Integration and Data Warehouse design knowledge.

Responsibilities

• ETL Process Development: Design, develop, and maintain ETL processes using Informatica PowerCenter or other relevant Informatica tools.
• Data Quality: Ensure data quality by implementing data cleansing and transformation processes.
• Data Modeling: Develop and maintain relational and dimensional data models.
• Troubleshooting: Identify and resolve issues in ETL processes.
• Collaboration: Collaborate with cross-functional teams to ensure successful implementation of ETL processes.

Skills

Informatica IDMC Developer

Oracle

Hadoop

Education

Bachelor's or Master's in Computer Science or related field

Tools

Informatica PowerCenter

Bit-Bucket

Job description

Siri InfoSolutions Inc. in Charlotte, NC seeks an experienced Informatica IDMC Developer to lead data integration and IDMC migration initiatives. You will design and implement ETL processes, ensure data quality, and work with cross-functional teams to deliver reliable data services.

Requirements include 10+ years of experience, expertise in Oracle and Hadoop ecosystems, strong SQL/PLSQL skills, and exposure to scheduling tools like Autosys.