Suraj Bais

Informatica ETL/ELT Developer with 7+ years of experience designing and delivering enterprise data integration solutions on Informatica Intelligent Data Management Cloud (IDMC/IICS) and Informatica PowerCenter, across cloud data integration (CDI), data migration, data warehousing, and production support. Strong hands-on SQL expertise across Microsoft SQL Server, Oracle, IBM DB2, and PostgreSQL for data extraction, transformation, validation, reconciliation, and performance optimization. Proven track record integrating heterogeneous sources — SAP, Salesforce CPQ, XML, Excel, CSV, and flat files — into enterprise targets with a focus on data quality, reliability, and scalable pipeline design.

Skilled in Informatica Secure Agent configuration and management, on-premises-to-cloud hybrid integration, workflow optimization, and error handling for high-availability ETL environments. Experienced in Agile/Scrum delivery using JIRA, API testing with Postman, SIT/UAT coordination, incident management, and root cause analysis (RCA) in cross-functional, onsite-offshore teams. Domain experience spanning Water Technology, Industrial Manufacturing, FMCG, and Financial Services, delivering high-performance data integration solutions in regulated, enterprise-scale environments.

ETL Developer – Hach Salesforce CPQ Project at Infosys Ltd. (2023-11 – 2026-04)

Stack: Informatica IDMC (IICS), Cloud Data Integration (CDI), SQL Server, Salesforce CPQ, XML, Excel, Flat Files, Secure Agent, JIRA, Agile

• Designed and developed scalable cloud ETL pipelines on Informatica IDMC (IICS) to integrate PIM, XML, Excel, flat file, and SQL Server data into Salesforce CPQ and downstream enterprise applications.
• Built and maintained mappings, mapping tasks, task flows, and reusable transformation logic (Lookup, Joiner, Router, Aggregator, Expression, Filter, Sorter, and Union) to support complex business rules.
• Configured and administered Informatica Secure Agent, cloud connections, and heterogeneous data sources to enable secure, reliable on-premises-to-cloud integration.
• Owned data extraction, transformation, validation, and reconciliation across incremental and full loads, ensuring high data quality and consistent integration with Salesforce CPQ.
• Improved pipeline throughput and reliability through performance tuning, mapping optimization, and SQL query tuning, and reducing job execution time.
• Led cloud migration and production deployment activities, including SIT/UAT support, defect resolution, RCA, release documentation, and scheduled job monitoring.
• Partnered with business users, onsite teams, and cross-functional stakeholders in an Agile/Scrum model using JIRA for sprint planning, story tracking, and defect management.

ETL Developer – Honeywell Project at Infosys Ltd. (2022-05 – 2023-11)

Stack: Informatica PowerCenter 10.x, Oracle Database, Oracle SQL Developer, IBM DB2, SAP HANA, SQL, JIRA, Agile

• Built and maintained ETL workflows in Informatica PowerCenter to integrate SAP and non-SAP data from IBM DB2 (Task Hub Interface) into SAP HANA via Oracle staging.
• Designed parameterized mappings, reusable transformations, workflows, and sessions using Lookup, Joiner, Aggregator, Router, Expression, Filter, Sorter, and Union transformations.
• Delivered ETL integration and data migration solutions in line with enterprise coding standards and development best practices.
• Drove unit testing, SIT, and UAT support, defect resolution, workflow optimization, and performance tuning to raise ETL efficiency and data accuracy.
• Maintained ETL documentation — test cases, mapping documents, workflow specs, JIRA stories, and deployment records — supporting production support and knowledge transfer.
• Collaborated with onsite teams and business analysts in an Agile/Scrum environment to ensure on-time sprint delivery and issue resolution.

ELT Developer – Unilever PLC Project at Tata Consultancy Services (TCS) (2019-12 – 2022-05)

Stack: Azure, DSP Monitor, SQL Server (SSMS), SAP, Syniti, ParkMyCloud, JIRA, Agile

• Supported and maintained the Azure-hosted DSP Monitor application, ensuring accurate, reliable reporting from SAP master data.
• Developed and enhanced ELT workflows to extract, validate, transform, and load Product, Customer, Pricing, Vendor, PLM, and BPM master data from SAP into SQL Server staging and DSP Monitor reports.
• Performed data validation, table joins, filtering, and reconciliation to ensure high data quality and compliance with business requirements.
• Handled production support including incident resolution, RFC implementation, RCA, and problem management for timely issue resolution.
• Coordinated with Syniti and Genpact teams to resolve reporting issues and support application enhancements in an Agile/Scrum environment.
• Executed code deployments and Disaster Recovery (DR) activities via ParkMyCloud to maintain business continuity and minimal downtime.

QA Engineer – Moody's Project at Tata Consultancy Services (TCS) (2018-10 – 2019-12)

Stack: PostgreSQL, SQL Server, DBeaver, Postman, JIRA, Agile (Kanban)

• Executed Functional, Regression, Smoke, UI, Database, and API testing to validate business requirements and ensure quality releases.
• Validated data integrity across PostgreSQL and SQL Server using DBeaver, ensuring consistency between application and database layers.
• Tested REST APIs using Postman, Insomnia, and Hoppscotch, verifying payloads, status codes, authentication, and business logic.
• Maintained test cases, scenarios, and defect reports in JIRA, ensuring full traceability and standards compliance.
• Collaborated with developers, BAs, and Product Owners in a Kanban environment across sprint planning, stand-ups, and defect triage.

Master of Computer Application in MCA – RTMNU, Rashtrasant Tukadoji Maharaj University (2018)

Bachelor of Computer Application in BCA – APSU, Awadhesh Pratap Singh University (2013)