Database Developer

Key Responsibilities:

• Design, develop, and maintain complex

  SSIS packages for ETL

  processes across different environments.
• Perform

  end-to-end data migration

  from legacy systems to modern platforms, ensuring data quality, integrity, and performance.
• Work closely with business analysts and data architects to understand data integration requirements.
• Optimize ETL workflows for performance and reliability, including incremental loads, batch processing, and error handling.
• Schedule and automate SSIS packages using SQL Server Agent or other tools.
• Conduct root cause analysis and provide solutions for data-related issues in production systems.
• Develop and maintain technical documentation, including data mapping, transformation logic, and process flow diagrams.
• Support integration of data between

  on-premises systems and Oracle Cloud (OCI)

  using SSIS and/or other middleware tools.
• Participate in code reviews, unit testing, and deployment support.

Education:

• Bachelors degree in Computer Science, Information Technology, or related field (or equivalent practical experience).

Required Skills:

• 5+ /  3+ years of hands-on experience in developing

  SSIS packages for complex ETL workflows

  .
• Strong SQL/T-SQL skills for querying, data manipulation, and performance tuning.
• Solid understanding of

  data migration principles

  , including historical data load, data validation, and reconciliation techniques.
• Experience in working with various source/target systems like flat files, Excel, Oracle, DB2, SQL Server, etc.
• Good knowledge of job scheduling and automation techniques.

Preferred Skills:

• Exposure or working experience with

  Oracle Cloud Infrastructure (OCI)

  – especially in data transfer, integration, and schema migration.
• Familiarity with

  on-premises-to-cloud

  and

  cloud-to-cloud

  data integration patterns.
• Knowledge of Azure Data Factory, Informatica, or other ETL tools is a plus.
• Experience in .NET or C# for custom script components in SSIS is advantageous.
• Understanding of data warehousing and data lake concepts.

  Role & responsibilities