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.RequirementsMin 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.
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.
Unison Consulting was launched in Singapore on September 2012, the hub of the financial industry, with innovative visions in the technocratic arena. We are a boutique next-generation Technology Company with strong business-interests in Liquidity risk, Market Risk, Credit Risk and Regulatory Compliance.
Unison provides technology consulting and services to implement Risk Management and Risk Analytics System for Financial Institutions. Our services suite comprises of Techno-Functional consulting, systems integration, Business Intelligence, information management, and custom development of IT solutions, plus project management expertise for financial institutions.
We have expertise in latest cutting edge technology to achieve better total cost of ownership. Through our qualified professionals, we assist you drive your unique risk management strategies, whether that means efficient monitoring, improving risk appetite of the financial institutions, complying with regulations, or capturing growth opportunities through innovation, this is what maximizes your decision taking potential. At Unison Consulting, we view clients as partners, and our success is only measured by the success of our partners. So we put it all on the table in order to exceed expectations.
Our staff consists of young, energetic and innovative consultants who are never afraid to challenge the conventions and push the boundaries in an effort to help our clients. For every project, no matter how large or how small, we strive to not only meet your needs, but deliver a showcase in your field.
Unison Consulting was launched in Singapore on September 2012, the hub of the financial industry, with innovative visions in the technocratic arena. We are a boutique next-generation Technology Company with strong business-interests in Liquidity risk, Market Risk, Credit Risk and Regulatory Compliance.
Unison provides technology consulting and services to implement Risk Management and Risk Analytics System for Financial Institutions.
Our services suite comprises of Techno-Functional consulting, systems integration, Business Intelligence, information management, and custom development of IT solutions, plus project management expertise for financial institutions.
We have expertise in latest cutting edge technology to achieve better total cost of ownership. Through our qualified professionals, we assist you drive your unique risk management strategies, whether that means efficient monitoring, improving risk appetite of the financial institutions, complying with regulations, or capturing growth opportunities through innovation, this is what maximizes your decision taking potential.
At Unison Consulting, we view clients as partners, and our success is only measured by the success of our partners. So we put it all on the table in order to exceed expectations.
Our staff consists of young, energetic and innovative consultants who are never afraid to challenge the conventions and push the boundaries in an effort to help our clients. For every project, no matter how large or how small, we strive to not only meet your needs, but deliver a showcase in your field.
