Technical Lead - Data Integration

Position Summary

The Technical Lead – Data Integration is responsible for leading the design, development, implementation, and support of enterprise data integration solutions. This role collaborates closely with enterprise architects, business stakeholders, project managers, and development teams to build scalable ETL processes, cloud integrations, and API-based solutions that enable reliable and secure data movement across enterprise applications.

The ideal candidate has strong experience with Informatica Intelligent Cloud Services (IICS), API integrations, SQL, cloud technologies, and enterprise data architecture, along with proven technical leadership and mentoring experience.

Key Responsibilities

Technical Leadership

• Lead the design and implementation of enterprise data integration solutions.
• Collaborate with architects, business analysts, and project managers to translate business requirements into scalable technical solutions.
• Define integration standards, development best practices, and coding guidelines.
• Conduct technical design reviews and code reviews.
• Mentor and coach junior integration engineers and data engineers.
  
  

Data Integration & ETL Development

• Design, develop, test, and deploy ETL/ELT processes using Informatica Intelligent Cloud Services (IICS).
• Build scalable data pipelines supporting enterprise reporting, analytics, and operational systems.
• Configure and manage cloud data connections within Informatica IICS.
• Install, configure, and maintain Informatica Secure Agents.
• Optimize ETL jobs for performance, scalability, and reliability.
  
  

API & Cloud Integration

• Develop integrations using REST APIs and enterprise connectors.
• Implement integrations with platforms including:
• Salesforce
• Workday
• Google Analytics
• Other cloud and SaaS applications
• Create and maintain OpenAPI (Swagger) documentation.
• Develop reusable API integration frameworks.
  

Workflow Automation

• Design and manage event-driven Taskflows.
• Implement workflow automation using:
• Event triggers
• Decision logic
• Loops
• Conditional routing
• Task assignments
  

Data Quality & Governance

• Investigate and resolve data quality issues.
• Perform root cause analysis for integration failures.
• Support Master Data Management (MDM) initiatives.
• Implement validation, reconciliation, and monitoring processes.
• Ensure data consistency across enterprise systems.
  
  

Database & SQL

• Develop complex SQL queries, stored procedures, and data validation scripts.
• Analyze data discrepancies and support data remediation.
• Optimize SQL performance for large datasets.
  
  

Production Support

• Monitor production integrations.
• Troubleshoot ETL failures and API issues.
• Coordinate deployments and production releases.
• Ensure SLA compliance for integration services.
  
  

Required Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
• 8+ years of experience in Data Integration or ETL development.
• 3+ years of technical leadership experience.
• Strong experience with Informatica Intelligent Cloud Services (IICS).
• Expertise in ETL/ELT design and implementation.
• Advanced SQL skills.
• Experience integrating enterprise applications using REST APIs.
• Experience with Salesforce and cloud applications.
• Strong understanding of API documentation using Swagger/OpenAPI.
• Experience with event-driven workflows and automation.
• Knowledge of Master Data Management (MDM).
• Excellent analytical and problem-solving skills.
• Strong communication and stakeholder management abilities.
  
  

Preferred Qualifications

• Informatica IICS certification.
• Experience with Salesforce integrations.
• Experience with Workday integrations.
• Experience with Google Analytics APIs.
• Experience with Azure or AWS cloud platforms.
• Knowledge of CI/CD pipelines and Git.
• Experience with Agile/Scrum methodologies.
• Experience working in nonprofit or healthcare organizations.
  
  

Technical Skills

ETL & Integration

• Informatica Intelligent Cloud Services (IICS)
• ETL / ELT Development
• Secure Agent
• Taskflows
• Mapping Designer
  
  

APIs

• REST APIs
• Swagger/OpenAPI
• JSON
• XML
  
  

Databases

• SQL Server
• Oracle
• PostgreSQL
• Advanced SQL
  
  

Enterprise Applications

• Salesforce
• Workday
• Google Analytics
  
  

Cloud

• Cloud Data Integration
• SaaS Integrations
• Cloud Connectors
  
  

Development Tools

• Git
• CI/CD
• Jira
  
  

Key Deliverables

• Enterprise-grade ETL pipelines
• Cloud-based data integrations
• API integrations
• Automated workflow solutions
• Reliable production support
• High-quality, governed enterprise data
• Technical documentation and standards
• Mentored and high-performing integration team
  
  

Share with someone awesome

Similar Openings

Senior Architect - AI Application & Agentic AI

Hyderabad +2 location

Wordpress Developer- Tech Lead

New Jersey +2 location

Dynamics 365 Business Central

Hyderabad

View all job openings