Onsite
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
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
SYNECHRON’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.
Want to know if this job is worth applying to?
