Nitin Dadwal

Client: NBN

Role: Senior Software Engineer

Project: Cloud Enterprise Data Warehouse (CEDW)

Responsibilities:

• Working on ELT pipelines in Redshift to load and transform data.
• Building and managing ETL pipelines using a homegrown SQL framework and PySpark-based SAF framework.
• Orchestrating jobs via IBM Workload Scheduler (IWS).
• Handling ingestion from AWS S3 and processing through Source Acquisition Layer (SAL), Conformed Access Layer (CAL), and End User Layer (EUL).
• Generating flat files for downstream applications and delivering via AWS S3, SharePoint, and Doc Manager.
• Supporting reporting layers consumed by Tableau, Power BI, Hyperion, and Starburst DV.

Client: Bank of America

Role: Technology Analyst

Responsibilities:

• Built automation scripts using UNIX shell scripting for DataStage jobs.
• Developed and maintained ETL workflows in DataStage.
• Participated in Agile ceremonies and incident resolution.
• Analyzed business requirements and validated solutions in collaboration with stakeholders.

Client: Discover

Role: Programmer Analyst

Responsibilities:

• Developed ETL pipelines using Informatica.
• Wrote reusable graphs for data cleansing, validation, and transformation.
• Automated production tasks using Unix Shell scripts.
• Participated in Agile processes including sprint planning and retrospective

Client: Vodafone India

Role: System Engineer

Responsibilities:

• Developed and maintained ETL jobs in DataStage.
• Profiled data and authored transformation specifications.
• Supported SIT/UAT and handled production deployments.
• Maintained documentation for business rules and metrics.
• Actively participated in project management tasks like onboarding and knowledge transfer.