> Drive end-to-end transformation and loading of the data from the different sources to target database (Oracle, Sybase) optimized for business and technical requirements using Informatica PowerCenter, Informatica Intelligent Cloud Services (IICS), Unix Shell, SQL, Azure, PowerBI, and SAS> Lead interaction with client (business and technical) to gather requirement, discuss and refine data migration approach> Recommend and lead the development of robust and scalable ETL solution. Transform the business requirement to optimal technical requirements considering business and technical constraints, source and target data systems, data formats, and APIs, etc. Create IICS connections using Azure connectors in IICS Administrator> Identify areas of continuous improvement and lead the optimization / performance tuning activities. Create reusable components such as code libraries, standardized ETL job templates, custom functions or transformation logic, error logging routines, alert mechanisms, automatic retry logic, workflow templates / orchestration scripts, testing frameworks etc. improving efficiency> Simplify complex mappings and transformations using expressions, aggregators, filters, sorter, sequence generator, remote lookups, etc. to create and populate data marts> Hands on experience in all major transformations – source qualifier, aggregator, router, joiner, rank, sequence generator, transaction control, lookup and re-usable, normalizer, external, expression transformations> Proficient in mapping data from various sources / destinations including but not limited to on-premise, cloud, commercial, proprietary systems. Capable of handling any source / destination data formats> Develop robust error handling mechanisms to identify, log, and handle errors. This includes alerting, and retry mechanisms> Improved performance by query plan optimization and code logic modification after performance testing

> Responsible for client stakeholder collaboration to understand the business requirements and underlying challenges. Provide recommendations factoring business and technical constraints> Own the design, development, and end-to-end implementation of SAP CPI and DS solutions connecting diverse set of applications and systems (on-prem and cloud), ensuring seamless data exchange and process automation> Develop data integration use cases, configure integration, map data between different systems / formats (XML, CSV, JSON, TXT, etc.), to establish connections between source and target systems> Expertise in deploying A2A and B2B solutions, utilizing SuccessFactors, IDOC, OData, RFC, File, SOAP, REST, FTP, Mail, SFTP, ProcessDirect, etc. adapters> Experience with several CPI integration capabilities and features – Mapping, Router, Multicast, Content Modifier, Data Store, Keystore Management, Security Artifacts, etc.> Develop custom functions, scripts, and transformations to manipulate and transform data, ensuring compatibility and consistency between integrated applications> Implement error handling mechanisms to manage exceptions, retries, and notifications in case of integration failures, ensuring robust and fault-tolerant integration processes> Ensure data security and compliance by implementing encryption, authentication, and authorization mechanisms within integration flows, following security best practices> Extract data from various source systems, databases, and applications using SAP DS, transform and cleanse data, mapping source data to target data structures, and performing necessary transformations ensuring accurate and efficient data extraction processes

> Perform transformation and loading of the data from the different sources to target database (Sybase) optimized for business and technical requirements using Informatica, Unix, SQL, and SAS> Responsible for maintaining the Coding Standards in accordance with the guidelines in Teradata and the quality procedures related to the project> Interact with client to gather and refine requirement and discuss high-level data migration approach> Recommended and developed software solution as per business requirement and provided options to client> Develop complex mappings and transformations using expressions, aggregators, filters, sorter, sequence generator and remote lookups to create and populate data marts> Develop and oversee execution of data migration plan from disparate data sources to the data warehouse> Designed and developed data feed from multiple data source / application of Fixed Value Chain> Improved performance by query plan optimization and code logic modification after performance testing> Supporting data warehouse application adhering to SLAs> Coordinate for issues resolution between client, external teams, and offshore team> Pre and Post deployment application support in production> Mentored team personnel for application / technical knowledge at onsite / offshore> Creating Complex Unix Scripts and schedules in Control – M> Understanding user requirements, system functionality and creating Software Requirements Specification document> Prepare test cases and write test scenarios> Test data preparation and loading data from other application databases> Deployment of package in test environment and resolving issues with respective developer or DBA team> Execution of test cases and raising defect towards respective team based on the issues> Track the defect and support respective developer or SDM to get it resolved, based on priority> Prepare and review the DSR and WSR with Clients and other stakeholders of the CR