Enterprise Data Integration Lead | Informatica, SQL, Cloud Platforms & Data Quality

Job Summary
Synechron is seeking an experienced ETL Informatica Developer to design develop and optimize scalable data integration solutions supporting data warehousing business intelligence and analytics initiatives. This role involves building robust ETL workflows ensuring high data quality and supporting enterprise data governance and performance standards. The ideal candidate will leverage extensive experience with Informatica tools and databases to deliver reliable high-performance data pipelines aligned with organizational objectives and industry best practices.

Software Requirements

Required Software Proficiency:

• Informatica PowerCenter / IDQ (latest version support) extensive experience in developing configuring and maintaining ETL workflows in enterprise environments

• SQL (Oracle SQL Server PostgreSQL or DB2) strong skills in complex query writing stored procedures and performance tuning supporting data validation and transformation

• Unix/Linux scripting (Bash Shell) proficiency supporting automation job scheduling and scripting support

• Data governance platforms supporting metadata management and data quality processes

• Data warehouse concepts: star schema snowflake schema SCDs fact and dimension tables supporting data modeling and schema design

Preferred Software Skills:

• Cloud platforms (Azure AWS GCP) supporting cloud-based data integration and migration (preferred)

• Data quality tools and frameworks supporting enterprise data validation and cleansing

• Automation tools supporting deployment and environment management support

Overall Responsibilities

• Design develop and maintain scalable ETL workflows supporting enterprise data warehouses and analytics platforms

• Optimize data pipelines for performance scalability and reliability in alignment with business goals

• Collaborate with data architects business analysts and data scientists to gather requirements and deliver data transformation solutions

• Support data migration schema changes and data refresh processes supporting regulatory and operational standards

• Conduct data validation reconciliation and quality assurance activities supporting compliance and data integrity

• Automate data load processes support job scheduling and manage workflow dependencies

• Improve existing ETL frameworks and implement best practices for reusable efficient and maintainable data pipelines

• Maintain thorough documentation of ETL processes data flow diagrams and operational procedures

Technical Skills (By Category)

• Languages & Data Tools (Essential):

  • SQL (Oracle SQL Server PostgreSQL DB2): supporting complex data transformations and validation

  • Informatica PowerCenter / IDQ: designing developing and troubleshooting workflows/supporting data pipelines

  • Unix/Linux scripting (Bash Shell): automating routine jobs and processes

• Data & Schema Management:

  • Data modeling schema design and data validation supporting enterprise data warehousing

• Cloud & Infrastructure Support:

  • Support for cloud data platforms (Azure AWS GCP) supporting migration storage and processing (preferred)

• Tools & Platforms:

  • Metadata management data quality and data governance frameworks supporting compliance and data lineage support

• Performance & Optimization:

  • Query tuning workflow scheduling and performance monitoring tools supporting large data volumes

Experience Requirements

• 6 to 7 years supporting enterprise data warehousing and ETL workflows in large-scale regulated environments

• Proven experience developing testing and maintaining scalable ETL workflows supporting analytics and migration projects

• Strong knowledge of data quality validation and reconciliation supporting compliance standards

• Experience with cloud data platforms (preferred) supporting hybrid cloud or cloud-native architecture

• Demonstrated ability to troubleshoot complex data pipeline issues and optimize performance in enterprise environments

Day-to-Day Activities

• Develop test and optimize ETL workflows supporting enterprise data warehousing and analytics

• Collaborate with data architects business analysts and data scientists to gather requirements and refine data pipelines

• Monitor data load performance troubleshoot pipeline failures and address data discrepancies

• Support data migration activities schema modifications and data refreshes supporting compliance and operational excellence

• Automate data workflows manage job dependencies and support environment configurations

• Ensure data security quality and metadata management adhering to industry and regulatory standards

• Document ETL processes workflows and data architecture supporting operational transparency and compliance

• Participate in code reviews performance tuning and process improvement initiatives supported by agile practices

Qualifications

• Bachelors or Masters degree in Data Engineering Computer Science or a related discipline

• 6 to 7 years supporting enterprise-scale data integration and warehousing projects

• Proven expertise with Informatica PowerCenter / IDQ supporting large data volumes and complex transformations

• Support experience with relational databases data modeling and data validation techniques supporting enterprise data quality

• Knowledge supporting cloud data platforms (Azure AWS GCP) supported migration and deployment efforts (preferred)

• Certification in Data Management Data Quality or Cloud Data platforms is a plus

Professional Competencies

• Strong analytical and troubleshooting skills for complex data workflow issues

• Leadership qualities to guide junior data engineers promote best practices and support team growth

• Effective communication skills to liaise with stakeholders data teams and compliance units

• Adaptability to evolving data standards cloud technologies and regulatory requirements

• Process improvement mindset supporting automation data quality and operational efficiency

• Organizational skills to prioritize multiple data projects platforms and compliance activities efficiently

SYNECHRONS DIVERSITY & INCLUSION STATEMENT

Diversity & Inclusion are fundamental to our culture and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity Equity and Inclusion (DEI) initiative Same Difference is committed to fostering an inclusive culture promoting equality diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger successful businesses as a global company. We encourage applicants from across diverse backgrounds race ethnicities religion age marital status gender sexual orientations or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements mentoring internal mobility learning and development programs and more.

All employment decisions at Synechron are based on business needs job requirements and individual qualifications without regard to the applicants gender gender identity sexual orientation race ethnicity disabled or veteran status or any other characteristic protected by law.

Candidate Application Notice