Rahul Bhaskar

Results-driven Data Engineer with 9+ years of experience in developing robust ETL and data integration solutions across Healthcare and Retail domains. Specialized in unitizing Informatica Cloud (CDI and CAI) along with SQL and scripting to integrate diverse cloud and on-premise data systems. Adept at mentoring team members to ensure high-quality, timely project delivery.

• Extensive experience in utilizing IICS CDI and CAI tools to enable batched and real time data processing between file server, database and API based data systems such as SQL Server, Oracle, Unix, Salesforce, SAP ECC, Amazon S3, Custom APIs etc.
• Implemented various ETL scenarios such as Incremental load, delta load, SCD, Ad hoc load, Data replication, Data synchronization etc based on business requirement. Also, implemented data cleansing and masking, error handling to ensure quality of data before loading into database.
• Hands on experience in optimizing ETL performance at integration level and database level using various techniques provided by Informatica. Also worked on real time scenarios to identify performance constraints such as Commit interval optimization, DTM buffer, data field precision, index optimization, override query tuning, cache files etc.
• Well experienced working with CAI to integration API based application. Involved in setting up service connectors, connections, process object etc and designed process to handle various scenario such as file parser, API GET, PUT, POST, json/xml file processing, fault handling, retry mechanism etc.
• Implemented Informatica iPaaS solution by sharing CAI processes as REST/SOAP API endpoint to client for real time processing. Configured synchronous/asynchronous calls, oAuth authentications, IP Filtering etc. to ensure smooth operation.
• Involved in Automation drives to automate existing business process using IICS capability to achieve cost and effort saving for client.
• Supported SDLC process by creating test scripts, HLD, LLD, TSD, Release plan, Component checklist, Rollback strategy to support code deployments and go live.
• Extensive experience in data analytics using advanced SQL techniques such as Joins, Subqueries, Common Table Expressions (CTEs), String Functions, and Unions to extract and analyse complex datasets.
• Experienced in optimizing SQL queries for improved performance, including indexing, query optimization, and managing database storage strategies.
• Familiar with Azure and AWS cloud services, including Storage, Compute, Data Warehousing, Integration, and Access Management.
• Experience working with REST API in IICS and Postman for uploading and extracting data in desired format. Familiar with different operation such as GET, POST, PUT and authentication methods.