Roles and Responsibilities
Exp of Informatica PowerCenter and/or Informatica IDQ experience.
Exp of SQL development experience using tools like Toad, Oracle SQL Developer, or Microsoft SQL Developer.
Proven extensive working experience on Informatica Power Center.
Perform ETL Transactions and develop Jobs to fetch data.
Knowledge of strong SQL Server but should be able to understand and develop complex database objects.
Should be able to develop complex Stored Procedures, Functions, Trigger, User-defined Functions, Views and Indexes.
Performance tuning of Informatica jobs is preferable.
Experience on Designing and Implementing ETL methodologies/solutions on basis of requirements.
Production support activities including on call support.
Experience in Azure Technologies like ADF, Storage Accounts is a positive to have.
Providing resolution of issues.
Monitoring of scheduled jobs and reports in case of issues.
Giving expert support and information to the queries raised by the end user.
Ability to work in a team driven workplace under stringent targets.
Good Analysis, Problem Solving skills and Interpersonal Skills.
Solid data analysis skills, with an attention to detail Ability to code in SQL