Informatica IDQ Developer

Required Information:

• Required Technical Skill Set: Informatica IDQ, Oracle PL / SQL SAS / TRIAD
• No of Requirements: 8
• Desired Experience Range: 2-4 years
• Location of Requirement: Airoli (Client location), Mumbai

Must-Have (Ideally should not be more than 3-5):

1. Perform Data Quality Scoping exercise and discover data quality requirements, contextual to Banking Industry.
2. Perform data quality profiling and review profiling results with responsible business divisions.
3. Discover data quality rules (Business & technical) that can show the exceptions in quality of data.
4. Propose recovery as well as resolution to the data quality issues
5. Take the data quality issues to a closure with the assistance of the Application teams.
6. Support end-to-end governance lifecycle that includes changes, projects and transformations.
7. Provide support in creating test cases for fixes to data quality issues.
8. Embrace IQ international, DAMA and EDM frameworks and cascade them to the internal frameworks.

Good-to-Have:

1. 1. Coding experience in SQL / Worked on TRIAD platform.
2. Customer orientation / Result orientation / planning organizing.
3. Good communication skills and team skills.
4. Experience / knowledge in Oracle / Informatica.
5. Banking domain experience is an added advantage.
6. Familiar with Data Governance and Data Quality control process
7. Competent knowledge of data quality tools such as Informatica, and Ataccama would be a plus
8. Strong knowledge of Relational Databases and Data Lakes experience a plus)
9. Project experience includes testing phases: System Integration (SIT) and User Acceptance (UAT) and efficient stakeholder communication
10. Understanding of operations, technology, and SDLC

Responsibility of / Expectations from the Role:

• Development of Informatica Mappings, create new tables with indexing for Performance Tuning, optimization of Informatica Mappings, strong in Oracle Pl/SQL. Be able to gather requirements from IT Manager or Business User
• Writing SAS / SQL codes to prepare scorecards / summary of data
• Optimizing already written codes to improve performance
• Creation of detailed documentation of each and every step performed
• Catering to adhoc requirements as per customer need