Description

You will design and develop data integration solutions using Informatica and cloud-based ETL tools.

This role is on-site.

Responsibilities

• Use Informatica DQ to profile, monitor, and control data quality.
• Design and develop relational database objects including tables, schemas, indexes, materialized views, and partitions.
• Implement dimensional models, query tools, and metadata repositories.
• Build and maintain stored procedures, macros, and database administration standards.
• Collaborate directly with business users to define and meet data requirements.

Required Skills

• 8+ years of experience in ETL development.
• Informatica Power Center 10.x/9.x.
• AWS Stack including Glue, Lambda, and Athena.
• Relational databases: Oracle, SQL Server, Teradata, DB2, PostgreSQL, and Redshift.
• Data modeling: Logical and physical modeling, Star and Snowflake schemas, OLAP, and OLTP.
• Languages: SQL, PL/SQL, UNIX Shell Scripting, and Python.
• Tools: Teradata Studio, Putty, SQL Developer, Autosys, ESP, Visio, and CA Workload Automation.
• Version control and CI/CD: SVN, Git, Jenkins, and Harness.
• Methodologies: Agile and Waterfall.

Preferred Skills

• Experience working within collaborative Agile teams.

Key Skills

Education

Any Graduate