Description

Develop ETL code and automation test suites for data mart applications. Design, build, and maintain data mart solutions using Informatica.

Responsibilities

• Design, develop, test, and maintain data mart applications using Informatica.
• Develop and deliver code enhancements, regression test suites, and automated testing routines.
• Troubleshoot, tune, and debug existing data mart applications and ETL code.
• Collaborate with product owners, developers, and analysts to clarify requirements and scope.
• Provide production support and maintenance for existing software and systems.

Required Skills

• 8+ years of overall professional experience.
• 5+ years of experience in Data Warehousing.
• 5+ years of experience with Informatica PowerCenter (versions 8, 9, or 10).
• 2+ years of experience with Informatica Cloud (IICS/IDMC).
• Experience with automation testing using Selenium and either Java or Python.
• Proficiency in SQL and Unix/Shell scripting for file movement and parameter updates.
• Strong knowledge of Data Modeling, Dimensional Modeling, Star, and Snowflake schemas.
• Experience working with Columnar Databases.
• Bachelor’s degree in Computer Science, Information Technology, or a related field.

Preferred Skills

• Experience with Cucumber for automation testing.

Key Skills

Education

Any Graduate