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):
- Perform Data Quality Scoping exercise and discover data quality requirements, contextual to Banking Industry.
- Perform data quality profiling and review profiling results with responsible business divisions.
- Discover data quality rules (Business & technical) that can show the exceptions in quality of data.
- Propose recovery as well as resolution to the data quality issues
- Take the data quality issues to a closure with the assistance of the Application teams.
- Support end-to-end governance lifecycle that includes changes, projects and transformations.
- Provide support in creating test cases for fixes to data quality issues.
- Embrace IQ international, DAMA and EDM frameworks and cascade them to the internal frameworks.
Good-to-Have:
- 1. Coding experience in SQL / Worked on TRIAD platform.
- Customer orientation / Result orientation / planning organizing.
- Good communication skills and team skills.
- Experience / knowledge in Oracle / Informatica.
- Banking domain experience is an added advantage.
- Familiar with Data Governance and Data Quality control process
- Competent knowledge of data quality tools such as Informatica, and Ataccama would be a plus
- Strong knowledge of Relational Databases and Data Lakes experience a plus)
- Project experience includes testing phases: System Integration (SIT) and User Acceptance (UAT) and efficient stakeholder communication
- 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