Provide technical knowledge/expertise to support the requirements definition, design, and development of data warehouse components/subsystems, specifically Extract-Transform-Load or Extract-Load-Transform technologies and implementations and/or Change Data Capture technologies and implementations.
Research, design, develop, and modify the ETL and related database functions, implementing changes/enhancements to the system
Design ETL processes and develop source to target data mappings, Data Synchronization tasks, and load processes.
Develop, test, integrate and deploy ETL code using ETL tools and external programming/scripting languages, as necessary.
Research, design, develop, and modify the Change Data Capture (CDC) and related functions
Administer and maintain the ETL/CDC environment, including performing configuration management activities related to the ETL/CDC environment
Resolve requests for assistance in troubleshooting issues assigned to the development team
Support functional/regression testing activities in support of system functionality releases, patches and upgrades
Support Production jobs and debug for any issues during Failures, perform the RCA for failure and fix the issue to resume the operations.
Knowledge in scheduling tools like TWS, Informatica Schedulers.
Analyze process improvement areas/recommend changes to processes/procedures for efficiencies/cost-savings/etc.