Description

You will design, develop, and implement complex ETL processes to support enterprise data warehousing, owning the full lifecycle from data source analysis to production deployment.

This role is on-site.

Responsibilities

• Design and develop Informatica ETL jobs based on business requirements and data models.
• Configure business rules and transformation logic within Informatica PowerCenter.
• Analyze and evaluate data sources, including mainframe extracts, flat files, SQL Server, and web services.
• Automate data extraction, transformation, and loading workflows, including job scheduling and dependency monitoring.
• Perform unit testing, system testing, and defect fixes for production and operational acceptance.

Required Skills

• 5+ years of experience in ETL development.
• Expertise in Informatica PowerCenter v10+.
• Proficiency in Python for data profiling and analysis.
• Advanced SQL skills for writing complex queries and performance tuning.
• Hands-on experience with SQL Server, Oracle, or Teradata.
• Experience with web services and various data source formats.
• Knowledge of version control tools such as Git or Bitbucket, including branching and code check-in.
• Experience with defect tracking tools and deployment processes for Informatica PowerCenter and IICS.

Preferred Skills

• Experience designing data models for Enterprise Data Warehousing (EDW).

Key Skills

Education

Any Graduate