Duties and responsibilities

· Good SQL development skill

· 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.

· Excellent understanding of T-SQL programming.

· Team player.

· Good time management skills.

· Great interpersonal and communication skills.