Job Description
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-4b++-8f44-544+4a31307b
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-4b++-8f44-544+4a31307b
💡 Quick Summary
Seeking a career-building opportunity? The Lead Data Engineer| Pune position is now open for candidates interested in the Database Administrator sector. This role in Pune offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in Database Administrator is a plus.