Description

Primary skills Roles and Responsibilities:
• Lead Data Modeler/Engineer who is proficient with Erwin Data Model tool.
• Build logical physical data models in Erwin
• Knows or has built DataVault models before.
• Understands existing Data Models,
• Design and write ETL Mapping specification with thorough understanding of grain and relationship of source and Target tables,
• Build SCD Type 2 mappings using Informatica Cloud IICS and or Powercenter.and/Or WhereScape or Erwin DataVault automation.
• Build Views in Snowflake Cloud Datawarehouse.
• Lead and Coordinate and review work with 3 other Sr Data Engineers.
• Decide Test strategy for each build and test using ICEDQ Automated Testing Tool.
• The associate needs to be familiar with agile development practice and needs to work with BSA, TSS, QA analyst and/or scrum master/Project Managers to define development goals on every 3-week basis.
• The developer needs to update his/her development status to the team and in Jira on daily basis and discuss issues/risks/blocks with the team and proactively seek help to resolve those and commit to the development goals
• The developer needs to be practitioner/expert in SQL and Informatica and or IICS ETL mapping design and development, follows best practices for coding and performance tuning and test-driven iterative development approach.
• The developer needs to be able to understand the logical mapping and data models provided and design and develop ETL mappings as per available patterns.
• The developer also needs to understand DevOps framework and use it to deploy code to production faster in an automated & repeatable way.

The Perfect Candidate Must Also Demonstrate The Following Qualities
• Entrepreneur: Self-manages time and tasks with minimal supervision, and proactively seeks help or guidance without hesitation.
• Problem-solver: Spots issues that others miss, methodically breaks down complex problems to identify root causes and creatively implements solutions.
• Change Agent: Is passionately interested in where the industry is heading and innately driven to innovate and embrace change
• Possibility thinker and go getter: Understands and follows priorities, works with end result in mind and works proactively to remove blocks or starts on alternate options.

Basic Skills
• Advanced SQL , 2)ETL Concepts, 3)SCD Type 2 Design and Development ,4)Data Analysis and Familiarity with Dimensional Data Modeling , 5)Problem Solving , Excellent Communication

Mandatory Skills

Design and Development of ETL Mapping Development using IICS / Informatica Powercenter), Snowflake as Cloud Warehouse

Tools And Technology

IICS- Informtica Cloud, Informatica Powecenter, Snowfalke Cloud Data Warehouse, Adavance anlytics SQL

Experience

8-11 years

Location:

Pune

Certification

Free Self faced Informatica Cloud Data Intgration Lab work completed

https://informatica.csod.com/ui/lms-learning-details/app/curriculum/1d7812ff-a874-4b99-8f44-54494a31307b