The Role
Leads the design, development, deployment, and support of enterprise data integration solutions using IICS, ETL/ELT, APIs, SQL, cloud platforms, and enterprise applications. Builds scalable pipelines, automated workflows, and governed data processes; troubleshoots production issues; supports data quality and MDM initiatives; and coordinates releases. Provides technical leadership through architecture collaboration, design and code reviews, standards development, stakeholder communication, and mentoring of integration and data engineering teams.
Summary Generated by Built In
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
Skills Required
- 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 Swagger/OpenAPI documentation
- 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
- 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
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Beyond Key is a global IT services and consulting company that helps organizations modernize and transform through Microsoft 365, Dynamics 365, cloud, business intelligence, data, artificial intelligence, automation, and custom software development. It delivers enterprise web, mobile, and cloud applications, integrations, and consulting, serving clients across the United States, Canada, Europe, Australia, and other markets as a long-term technology partner.
