Description

Key Responsibilities

- Complete Data Modelling Tasks o Initiate and manage Gap Analysis and Source-to-Target Mapping Exercises.

o Gain a comprehensive understanding of the EA extract.

o Map the SAP source used in EA extracts to the AWS Transform Zone, AWS Conform Zone, and AWS Enrich Zone.

o Develop a matrix view of all Excel/Tableau reports to identify any missing fields or tables from SAP in the Transform Zone.

o Engage with SME’s to finalize the Data Model (DM).

o Obtain email confirmation and approval for the finalized DM.

o Perform data modelling using ER Studio and STTM.

o Generate DDL scripts for data engineers to facilitate implementation.

- Complete Data Engineering Tasks o Set up infrastructure for pipelines – this includes Glue Jobs, crawlers, scheduling, step functions etc.

o Build, deploy, test and run pipelines on demand in lower environments.

o Verify data integrity: no duplicates, all columns in final table etc.

o Write unit tests for methods used in pipeline and use standard tools for testing.

o Code formatting and linting.

o Collaborate with other Modelling Engineers to align on correct approach.

o Update existing pipelines for CZ tables (SDLF and OF) where necessary with new columns if they are required for EZ tables.

o Raise DDP requests to register databases and tables, and to load data into the raw zone.

- Create comprehensive positive documentation. Ensure each task is accompanied by detailed notes specific to its functional area for clear tracking and reference.
- Analyse and manage bugs, and change requests raised by business/SMEs.
- Collaborate with Data Analyst and Virtual Engineers (VE) to refine and enhance semantic modelling in Power BI.
- Plan out work using Microsoft Azure, ADO. Dependencies, status and effort is correctly reflected.

Enable Skills-Based Hiring No ECMS REQ IDAdditional Details

- ECMS REQ ID : 584208




- Project Location 1 : Pan India
- Project Location 2 : (No Value)
- Project Location 3 : (No Value)
- Project Location 4 : (No Value)
- Delivery SPOC : Nishit Kumar
- Relevant Experience : 6+ years
- Mandatory skills : Required Skills and Experience: • Proven experience in data modelling and data pipeline development. • Proficiency with tools like ER Studio, STTM, AWS Glue, Redshift & Athena, and Power BI. • Strong SQL and experience with generating DDL scripts. • Experience working in SAP data environments. • Experience in any of these domain areas is highly desirable: Logistics, Supply Planning, Exports and IFOT. • Familiarity with cloud platforms, particularly AWS. • Hands-on experience with DevOps and Agile methodologies (e.g., Azure ADO). • Strong communication and documentation skills. • Ability to work collaboratively with cross-functional teams.
- Desired skills : Required Skills and Experience: • Proven experience in data modelling and data pipeline development. • Proficiency with tools like ER Studio, STTM, AWS Glue, Redshift & Athena, and Power BI. • Strong SQL and experience with generating DDL scripts. • Experience working in SAP data environments. • Experience in any of these domain areas is highly desirable: Logistics, Supply Planning, Exports and IFOT. • Familiarity with cloud platforms, particularly AWS. • Hands-on experience with DevOps and Agile methodologies (e.g., Azure ADO). • Strong communication and documentation skills. • Ability to work collaboratively with cross-functional teams.
- Domain (Industry) : Oil & Gas
- BGC (Before onboarding / After onboarding) : PreOB
- Total Experience (Ex. 5-7 Years) : 6+ years
- BGC Details : Standard Infosys checklist
- BGC Vendor : Any NASSCOM Vendor
- Mode of Interview : Face to Face
- WFO / WFH / Hybrid : Hybrid
- Please enter shift timings : UK Shift
- Shift Timings : Afternoon

📌 584208 | IC | Data Modeler | INDIA
🏢 Trigent Software
📍 India