Company:IT Services Organization

Key Skills: Shell Scripting, UNIX, PowerCenter, SQL Server, ETL, Informatica, CICD

Roles and Responsibilities:

- Design, develop, and maintain ETL/ELT mappings, workflows, taskflows, and data pipelines using Informatica IDMC and PowerCenter.
- Develop efficient and optimized SQL queries for data extraction, transformation, and validation.
- Work with databases such as Oracle, SQL Server, Teradata, or similar relational databases.
- Develop and maintain data integration solutions supporting business and data warehousing requirements.
- Implement SCD, incremental loads, and other data warehousing methodologies.
- Participate in data migration projects, including data extraction, transformation, validation, and loading.
- Develop and maintain Unix/Shell scripts for ETL processing and operational activities.
- Work with Autosys or similar scheduling tools to schedule and monitor ETL jobs.
- Support and maintain CI/CD pipelines for deployment and release management.
- Troubleshoot ETL failures,



performance issues, data quality problems, and production incidents.
- Perform unit testing, integration testing, data validation, and defect resolution.

Skills Required:

- Strong experience in Informatica IDMC and PowerCenter.
- Hands-on experience in ETL/ELT mappings, taskflows, workflows, and data pipelines.
- Robust SQL skills with Oracle, SQL Server, Teradata, or similar databases.
- Good understanding of Data Warehousing, Star Schema, SCD, and incremental loads.
- Experience with data migration projects.
- Knowledge of Unix/Shell scripting and Autosys or similar scheduling tools.
- Basic experience with CI/CD pipelines.
- Strong problem-solving and communication skills.
- Ability to work independently and mentor junior developers.
- Banking/Financial Services domain experience is a plus.

Education: Bachelor's Degree in related field

📌 Informatica Developer (Chennai)
🏢 MyCareernet
📍 Chennai