Job Description :
Review and understand data model
Assist with effort estimation and WBS planning
Assist ETL Architect in Solution Architecture
Responsible for creating ETL design (Data Flow Diagrams) and Technical/Mapping Specs (Table Builder, SSIS packages, SQL,
Orchestrator run books ) based on the BRD, Source data and target Data Model
Perform POCs to validate design
Delegate development and Testing tasks to Offshore and coordinate the progress and resolve any issue blocking the development.
Develop complex ETL code components/ templates(Table Builder, SSIS packages, SQL, Orchestrator run books) and Unit test.
Review Code for standards as well as working-as-designed and ensure source code is checked in Git.
Review test cases and test results, identify defects, issues and provide guidance for offshore to resolve them.
Plan, document and execute deployment, support transition run books
Manage development environment and coordinate historical data loads and prod cut-over and hyper care.