Design, develop, test, and deploy data integration solutions using Informatica Intelligent Cloud Services (IICS), specifically Cloud Data Integration (CDI) and Cloud Application Integration (CAI). Build, manage, and optimize complex SQL queries, ETL pipelines, data warehouse solutions, and large-scale database workflows. Develop batch and real-time/near-real-time integrations using
REST/SOAP
APIs, web services, application connectors, authentication, and pagination. Perform source-to-target analysis, data profiling, mapping specifications, data validation, reconciliation, and defect identification. Optimize ETL mappings, workflows, and database queries while supporting unit testing, quality assurance, and deployments. Monitor production systems, analyze logs, troubleshoot failed data loads, manage incidents, perform root cause analysis (RCA), and maintain technical documentation. Work with clients and data architects in Agile/Scrum environments.
Good-to-have skills:
Python scripting, Power BI/Tableau, and data architecture knowledge.