Job Description

The highlight of the engagement opportunity

Nature of role: Full time
Number of years of experience expected: 2-5 years
Areas of past experience preferred: Data management/ ETL
Educational qualification expected: Graduate degree in Management/ Data Science/ Bachelor’s
Degree in Engineering
Additional qualifications/ certifications required: None
Preferable additional certifications: None
Preferred geography of previous work experience: India
Language requirements: Ability to write and speak fluently in English
Application experience: SQL, Informatica

Key responsibility areas:

• Formulating management techniques for quality data collection to ensure adequacy, accuracy and the integrity of the data
• Must have experience in building complex SQL queries and Shell scripting
• Strong on data warehousing fundamentals and concepts
• Extensive experience around data modeling and architecture
• Understands and review technical requirements, designs ETL process flow and walkthroughs and  performs data profiling of required source systems
• Strong analytical skills (able to read/write complex SQL queries to analyse data, investigate defects, validate data quality).
• Experience of working on SQL Server 2012/2014/2016, SQL Server Integration Services (SSIS),
• SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS)
• Experience of working on Informatica PowerCenter Repository, PowerCentre Designer,
• PowerCenter Workflow Manager and PowerCenter Monitor
• Identifying valuable data sources and automate collection process
• Build transformation algorithms and scripts for computational transformations using ETL
• Demonstrate independence in planning and stakeholder engagement, testing design and execution, results interpretation and presentation, and the production of documentation strong enough to evidence a sound challenge to both internal and external parties
• Responsible for client delivery
• Understand the client’s business, key strategic essentials of the client, industry and market dynamics, and make/ implement recommendations appropriate for the client’s business needs to drive continuous improvement and generate value
• Stakeholder management in a project along with project man