Develop and enhance ETL workflows from various sources to MSSQL database/PostgreSQL DB
Perform development activities using Informatica IDMC services.
Creates, maintains, and optimizes stored procedures, functions, inline SQL, database structures, and ETL processes to adapt to changes in needs and requirements.
Works cooperatively with others to resolve data and process issues.
Responsible for developing and managing ETL configurable artifacts (code, environment, configuration files, documentation).
Requirements
BS/MS degree in Computer Science, Engineering, or a related subject.
2 to 3 years of Data Analytics experience.
2 to 3 years of ETL experience is a plus.
Current experience with Informatica PowerCenter v10.5+.
Experience with migration of Informatica PowerCenter to IDMC.
Experience with performance tuning of sources, mappings, targets and sessions.
Familiarity with Microsoft SQL Server/PostgreSQL DB.
