KEY SKILL -

ETL/ELT Development using Informatica

Power Center and Teradata

Data Platform Expertise

Data Pipeline & Orchestration using enterprise scheduling tools

Performance Optimization

Data Integration & CDC

MDM - Reference data management

ETL Framework & Automation Development

KEY RESPONSIBILITES AND SKILL SET

• Create EDW ETL/ELT codes using Teradata SQL, Informatica, Apache Spark, QueryGrid, Trino to perform various transformations and load into Teradata based data warehouse or datamarts

- Performance tuning of highly complex applications to reduce resource

- Create framework using GCFR, shell scripts, BTEQ and shell scripts to automate end to end. Also to integrate with control

- Build in-house CDC framework using Java to process OR logs from SAP(Oracle) and ingestion the data into Teradata. Create framework around this CDC ingestion to make it configurable