ABOUT <\/span><\/span><\/span><\/span>CoorB<\/span><\/span><\/span><\/b>
<\/span><\/span><\/p><\/div>We build full\-fledged innovative solutions with a focus on process automation, user experience enhancement, and advanced data analytics. With our extensive industry <\/span>expertise, we help achieve operational excellence, future\-proof your IT investments, and ensure a competitive edge in the ever\-evolving finance industry.<\/span><\/span><\/span>
<\/span><\/span><\/p><\/div>
<\/p><\/div>
OUR OPPORTUNITY<\/span><\/span><\/span>
<\/span><\/span><\/p><\/div>The ETL Developer supports existing integration pipelines while building, migrating,\u202foptimizing, and\u202fvalidating\u202ftarget\-state ETL/ELT pipelines.<\/span><\/span><\/span>
<\/span><\/span><\/p><\/div>YOU WILL<\/span><\/span><\/span>
<\/span><\/span><\/p><\/div>- Maintain and support existing ETL pipelines across Informatica, DataStage, SSIS, Oracle procedures, or other tools.\u202f<\/span><\/span><\/span><\/span>
<\/span><\/span><\/span><\/li><\/ul><\/div>- Analyze current pipeline logic, dependencies, schedules, transformations, and failure points.\u202f<\/span><\/span><\/span><\/span>
<\/span><\/span><\/span><\/li><\/ul><\/div>- Document existing source\-to\-target mappings and transformation rules.\u202f<\/span><\/span><\/span><\/span>
<\/span><\/span><\/span><\/li><\/ul><\/div>- Build new target\-state pipelines using approved ETL/ELT technologies.\u202f<\/span><\/span><\/span><\/span>
<\/span><\/span><\/span><\/li><\/ul><\/div>- Migrate selected legacy ETL logic into modern pipelines.\u202f<\/span><\/span><\/span><\/span>
<\/span><\/span><\/span><\/li>- Implement batch, incremental, CDC, and streaming ingestion patterns.\u202f<\/span><\/span><\/span><\/span>
<\/span><\/span><\/span><\/li><\/ul><\/div>- Develop cleansing, validation, enrichment, and error\-handling logic.\u202f<\/span><\/span><\/span><\/span>
<\/span><\/span><\/span><\/li><\/ul><\/div>- Support data reconciliation between current and target platforms.\u202f<\/span><\/span><\/span><\/span>
<\/span><\/span><\/span><\/li><\/ul><\/div>- Optimize\u202fpipeline performance and reduce redundant data movement.\u202f<\/span><\/span><\/span><\/span>
<\/span><\/span><\/span><\/li><\/ul><\/div>- Implement audit logging, exception handling, monitoring, and\u202f<\/span>restartability<\/span>.\u202f<\/span><\/span><\/span><\/span>
<\/span><\/span><\/span><\/li><\/ul><\/div>- Support decommissioning of legacy ETL jobs after successful migration. <\/span><\/span><\/span><\/span>
<\/span><\/span><\/span><\/li><\/ul><\/div><\/div>
<\/span><\/li><\/ul><\/span>
Requirements<\/h3>TO BE SUCCESSFUL IN THE ROLE YOU NEED<\/span><\/span><\/span>
<\/span><\/span><\/p><\/li><\/ul>- Strong SQL and database experience.\u202f<\/span><\/span><\/span>
<\/span><\/span><\/li>- Experience with ETL tools such as Informatica, DataStage, SSIS, ODI, Talend, Azure Data Factory, Databricks, or similar.\u202f<\/span><\/span><\/span>
<\/span><\/li><\/ul><\/div>- Understanding of<\/span>\u202fDWH, ODS, staging,\u202f<\/span>lakehouse<\/span>, and data mart patterns.\u202f<\/span><\/span><\/span>
<\/span><\/li><\/ul><\/div>- Experience with batch loads, incremental loads, CDC, SCD handling, and reconciliation.\u202f<\/span><\/span><\/span>
<\/span><\/li><\/ul><\/div>- Knowledge of data quality rules, audit logging, error handling, and job monitoring.\u202f<\/span><\/span><\/span>
<\/span><\/li><\/ul><\/div>- Experience with cloud data platforms, Spark,\u202f<\/span>dbt<\/span>, or\u202f<\/span>lakehouse<\/span>\u202ftechnologies is preferred.\u202f<\/span><\/span><\/span>
<\/span><\/li><\/ul><\/div><\/div>
<\/div><\/span>
