Before u proceed below to check the jobs/CVs, please select your favorite job categories, whose top job alerts you want in your email & Subscribe to our Email Job Alert Service For FREE
Job Location: Pune
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.
1. 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.
2. 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
3. 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.
4. 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.
5. 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:
1)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
Submit CV To All Data Science Job Consultants Across Bharat For Free