Job Description

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

• Bachelor’s or Master’s 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

S​YNECHRON’S 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 applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law

Candidate Application Notice