Relevant Years of Experience :

4-8 years

Number of open positions : 1

 

Skills: 

  • AWS Redshift; Microsoft SQL Server; MDM; Profisee; Informatica IICS;Shell Scripting; Python

  • Good knowledge of dimensional modeling and DWH concepts like change data capture (CDC)

  • SQL Programming: Knowledge in basic and advanced concepts like PL/SQL, analytical functions etc.

  • Ensuring accuracy and integrity of data and applications through analysis, coding, documenting, testing, and problem solving

  • Efficient in coding and understanding the deliverables.

Requirement:

  • Do initial understanding of the Technical and functional requirements from the Jira and raise clarification. Participate in the Technical and Functional walk-through from Onsite to offshore.

Development:

  • Develop the MDM matching rules and survivorship rules based on the MDM rule book.

  • Adhere to the development standards.

  • Perform Data Profiling

  • Develop – Data Quality Reports.

Unit Testing:

    • Perform the Data Validation testing for History and Ongoing Data load.

    • Do Performance Testing and check whether the jobs runs within the stipulated time frame.

Detect Fixes:

    • Participate in DRM calls and understand the defects in the module.

    • Perform Defect fixes and communicate the fix to QA team.

    • Communication: Update the daily status to project stake holders.

    • Excellent verbal and written communication skills