Senior Data Integration Developer

Key Responsibilities

• Design, develop, test, and maintain enterprise-grade ETL solutions using SQL Server Integration Services (SSIS) and Informatica Power Center
  .
• Build, optimize, and support data integration workflows to meet business and operational requirements.
• Design and implement scalable data warehousing solutions.
• Execute and support large-scale data migration projects while ensuring data quality, consistency, and integrity.
• Develop, optimize, and maintain Oracle PL/SQL packages, procedures, functions, and triggers.
• Develop advanced T-SQL scripts, stored procedures, and optimize performance in Microsoft SQL Server
  .
• Analyze business and technical requirements and recommend scalable data integration solutions.
• Troubleshoot ETL failures, resolve performance bottlenecks, and address data quality issues.
• Collaborate with business stakeholders, solution architects, database administrators, and development teams to deliver high-quality solutions.
• Adhere to coding standards, documentation best practices, and change management processes.
• Participate actively in Agile ceremonies, including sprint planning, daily stand-ups, sprint reviews, and retrospectives.

• Min 5+ Years of experience in SQL Server Integration Services (SSIS 2019) for designing, developing, and deploying ETL solutions.
• Extensive experience in Informatica Power Center development, including ETL workflows, mappings, and performance optimization.
• Proven expertise in enterprise ETL architecture, design, development, and optimization for large-scale data integration projects.
• Strong understanding of data warehousing concepts
  , including dimensional modeling, data marts, and ETL best practices.
• Hands-on experience in data migration planning, execution, validation, and reconciliation across enterprise systems.

Database Technologies

• Strong experience with Oracle Database administration and development.
• Expertise in Oracle PL/SQL programming, including packages, procedures, functions, triggers, and performance tuning.
• Extensive experience with Microsoft SQL Server development and administration.
• Advanced proficiency in T-SQL
  , including query optimization, indexing strategies, stored procedures, and performance tuning.