About the role
• Collaborate with business analysts to understand and refine requirements. • Translate mapping requirements into Informatica mappings, sessions, and workflows. • Tune Informatica mappings and database queries for performance. • Identify performance bottlenecks and implement appropriate optimizations. • Create shell scripts to automate recurring operational tasks. • Prepare test cases and document unit-test results. • Schedule and monitor jobs using AutoSys or a comparable scheduling tool.
Must-have : • Experience with Informatica PowerCenter, including Designer, Repository Manager, and Workflow Manager. • Experience building complex SQL queries and shell scripts. • Strong understanding of Oracle and SQL Server database models. • Experience extracting, transforming, and loading data from sources such as flat files, Oracle and SQL Server databases, and mainframe files.
Good-to-have : Knowledge of AutoSys, Jira, Power Exchange, and Agile methodologies. Qualifications: BACHELOR OF ENGINEERING