What are the responsibilities and job description for the ETL Engineer position at MigrationIT?
- Design and develop end-to-end ETL processes using Informatica PowerCenter.
- Work on Data Mapping sheets, and document mapping process between source and target
- Analyze source system data, identify data quality issues, and implement data cleansing mechanisms.
- Optimize ETL processes for performance, scalability, and reliability.
- Perform data integration and transformation using various data sources like relational databases, flat files, and APIs.
- Develop and maintain mappings, sessions, and workflows within PowerCenter to ensure accurate and timely data flow.
- Collaborate with data architects and business analysts to design data models and data flows.
- Ensure that all ETL processes comply with data governance policies and standards.
- Bachelor degree in computer engineering, computer science or any equivalent.
- 2-3 years of experience in the same position.
- Experience in Informatica Power Center.
ETL Developer
ACS Consultancy Services, Inc -
Albany, NY
ETL Developer (IBM DataStage)
ACS Consultancy Services, Inc -
Albany, NY
Lead ETL DataStage Developer
Donato Technologies, Inc. -
Albany, NY