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.

• 
  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.