The Role
Develop and optimize ETL/ELT pipelines using Informatica, Teradata, Hadoop, Spark, and related technologies. Build data warehouse and data mart solutions, automate workflows with shell scripts and BTEQ, create Java-based CDC frameworks for SAP and Oracle data, and implement configurable ingestion processes. Install and develop MDM applications with data validation and approval workflows. Tune complex applications to improve performance and reduce resource consumption.
Summary Generated by Built In
- Strong hands‑on experience with the ETL(Informatica
Power Center) and Teradata based ETL development, similarly Hadoop
ecosystem (Hive, Impala, Spark, Kafka, Iceberg, Ranger, Atlas, Nifi, Flink
etc.,), and data pipeline orchestration.
- Create EDW ETL/ELT codes using Teradata SQL,
Informatica, apache Spark, QueryGrid, Trino to perform various
transformation and load into Teradata based data warehouse or datamarts
- Performance tuning of highly complex applications to
reduce resource usage
- 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 OLR
logs from SAP(Oracle) and ingestion the data into Teradata. Create
framework around this CDC ingestion to make it configurable
- Install and build Master Data Management(MDM)
application for various user uploads along with data validations and
approval workflow
Skills Required
- Strong hands-on experience with Informatica PowerCenter and Teradata-based ETL development
- Experience with Hadoop ecosystem technologies, including Hive, Impala, Spark, Kafka, Iceberg, Ranger, Atlas, NiFi, and Flink
- Experience with data pipeline orchestration and Teradata SQL
- Experience creating ETL/ELT code using Informatica, Apache Spark, QueryGrid, and Trino
- Experience tuning complex applications to reduce resource usage
- Experience with GCFR, shell scripting, BTEQ, and end-to-end automation frameworks
- Java development experience for change data capture and data ingestion frameworks
- Experience processing SAP and Oracle OLR logs and ingesting data into Teradata
- Experience installing or building Master Data Management applications with validation and approval workflows
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Technopals provides IT solutions to organizations, including IT security services, talent acquisition, enterprise IT infrastructure, and software development. Serving organizations across Asia Pacific and other global markets, it works with businesses of all sizes to help them meet infrastructure needs and gain value from technology. Its approach emphasizes established industry practices, client service, and practical IT solutions.
.jpeg)
