The Role
Maintain, migrate, build, and optimize ETL/ELT pipelines; analyze and document source-to-target mappings; implement batch, incremental, CDC, and streaming ingestion; add validation, cleansing, error-handling, monitoring, and audit logging; reconcile data and decommission legacy jobs post-migration.
Summary Generated by Built In
ABOUT CoorB
We build full-fledged innovative solutions with a focus on process automation, user experience enhancement, and advanced data analytics. With our extensive industry expertise, we help achieve operational excellence, future-proof your IT investments, and ensure a competitive edge in the ever-evolving finance industry.
OUR OPPORTUNITY
The ETL Developer supports existing integration pipelines while building, migrating, optimizing, and validating target-state ETL/ELT pipelines.
YOU WILL
- Maintain and support existing ETL pipelines across Informatica, DataStage, SSIS, Oracle procedures, or other tools.
- Analyze current pipeline logic, dependencies, schedules, transformations, and failure points.
- Document existing source-to-target mappings and transformation rules.
- Build new target-state pipelines using approved ETL/ELT technologies.
- Migrate selected legacy ETL logic into modern pipelines.
- Implement batch, incremental, CDC, and streaming ingestion patterns.
- Develop cleansing, validation, enrichment, and error-handling logic.
- Support data reconciliation between current and target platforms.
- Optimize pipeline performance and reduce redundant data movement.
- Implement audit logging, exception handling, monitoring, and restartability.
- Support decommissioning of legacy ETL jobs after successful migration.
Requirements
TO BE SUCCESSFUL IN THE ROLE YOU NEED
- Strong SQL and database experience.
- Experience with ETL tools such as Informatica, DataStage, SSIS, ODI, Talend, Azure Data Factory, Databricks, or similar.
- Understanding of DWH, ODS, staging, lakehouse, and data mart patterns.
- Experience with batch loads, incremental loads, CDC, SCD handling, and reconciliation.
- Knowledge of data quality rules, audit logging, error handling, and job monitoring.
- Experience with cloud data platforms, Spark, dbt, or lakehouse technologies is preferred.
Skills Required
- Strong SQL and database experience.
- Experience with ETL tools such as Informatica, DataStage, SSIS, ODI, Talend, Azure Data Factory, Databricks, or similar.
- Experience maintaining and supporting ETL pipelines, including Oracle procedures.
- Understanding of DWH, ODS, staging, lakehouse, and data mart patterns.
- Experience with batch loads, incremental loads, CDC, SCD handling, and reconciliation.
- Knowledge of data quality rules, audit logging, error handling, and job monitoring.
- Experience with cloud data platforms, Spark, dbt, or lakehouse technologies.
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
