Description

What's the Job?

• Develop complex ETL workflows using Informatica PowerCenter, including data mapping to ingest from disparate sources such as flat files, RDBMS, Hive, and REST APIs.
• Create and maintain Unix scripting to support ETL execution and operational needs.
• Perform performance tuning across targets, sources, mappings, and SQL queries to improve reliability and efficiency.
• Develop test cases and execute unit testing to validate ETL logic and data quality.
• Coordinate with distributed team members and provide regular task status updates to management.

What's Needed?

• Strong technical proficiency in Informatica PowerCenter, including ETL development and mapping design.
• Strong performance tuning skills for targets, sources, mappings, and SQL queries.
• Solid conceptual knowledge of PL/SQL (including functions) and the ability to write complex SQL, create and expose views/materialized views.
• Strong Unix command and scripting skills to support ETL workflows.
• Good MuleSoft integration knowledge and the ability to work independently with minimal supervision

Key Skills

Education

Any Graduate