We are looking for a Senior Data Integration Developer with strong expertise in SSIS, Informatica PowerCenter, Oracle, and Microsoft SQL Server to design, develop, and maintain enterprise-grade data integration and ETL solutions.
Key Responsibilities:
Design, develop, test, and maintain enterprise-grade ETL solutions using SQL Server Integration Services (SSIS) and Informatica PowerCenter.
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
Requirements
Min 5+ Years of experience in SQL Server Integration Services (SSIS 2019) for designing, developing, and deploying ETL solutions.
Extensive experience in Informatica PowerCenter 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
