Job Description
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