ETL Developer + Snowflake + Hadoop + Informatica

Job Summary

Synechron is seeking a skilled ETL Developer with strong expertise in Hadoop ecosystems, Spark, and Informatica to design, develop, and maintain scalable data pipelines supporting enterprise analytics and data warehousing initiatives. This role involves working on large datasets, transforming data, and delivering reliable data integration solutions across on-premise and cloud environments. Your efforts will enable data-driven decision-making, ensure data quality, and support our organization’s strategic focus on scalable and compliant data platforms.

Software Requirements

Required:

• Hands-on experience with ETL tools: Informatica, Talend, or equivalent (5+ years)

• Proven expertise in Hadoop ecosystem components: HDFS, Hive, Pig, Sqoop (5+ years)

• Proficiency in Apache Spark: PySpark, Spark SQL, Spark Streaming

• Strong programming skills in Python, Java, or Scala for data processing (5+ years)

• Experience with SQL and relational databases: Oracle, MySQL, PostgreSQL

• Familiarity with cloud data platforms such as AWS Redshift, Azure Synapse, GCP BigQuery

Preferred:

• Knowledge of cloud-native data migration and integration tools

• Exposure to NoSQL databases like DynamoDB or Cassandra

• Experience with data governance and metadata management tools

Overall Responsibilities

• Design, develop, and optimize end-to-end ETL pipelines for large-scale data processing and integrations

• Build and enhance batch and real-time data processing workflows using Spark, Hadoop, and cloud services

• Convert business and technical requirements into high-performance data solutions aligned with governance standards

• Perform performance tuning, debugging, and optimization of data workflows and processing jobs

• Ensure data quality, security, and compliance with enterprise standards and industry regulations

• Collaborate with data analysts, data scientists, and application teams to maximize data usability and accuracy

• Automate data ingestion, transformation, and deployment pipelines for operational efficiency

• Support platform stability by troubleshooting issues, monitoring workflows, and maintaining data lineage

• Implement and improve data governance, metadata management, and security standards

• Stay current with emerging data technologies, automation frameworks, and cloud innovations to optimize data architectures

Technical Skills (By Category)

Programming Languages (Essential):

• Python, Scala, Java (for data processing and automation)

Preferred:

• Additional scripting or programming skills (Shell, SQL scripting)

Frameworks & Libraries:

• Spark (PySpark, Spark SQL, Spark Streaming), Hive, Pig

• Data validation and governance tools (e.g., Atlas, Data Catalogs)

• AI/ML frameworks such as LangChain, Hugging Face (preferred)

Databases & Storage:

• Relational: Oracle, PostgreSQL, MySQL

• NoSQL: DynamoDB, Cassandra (preferred)

Cloud Technologies:

• AWS: EMR, S3, Glue, CloudFormation, CDK, Redshift (preferred)

• Azure or GCP data services (desired)

Data Management & Governance:

• Metadata management, data lineage, data quality frameworks

DevOps & Automation:

• CI/CD tools: Jenkins, GitHub Actions, TeamCity

• Infrastructure as Code: Terraform, CloudFormation, Ansible

Experience Requirements

• 4+ years of experience in designing and developing large-scale data pipelines

• Proven expertise with Hadoop, Spark, and ETL frameworks in enterprise environments

• Hands-on experience integrating data within cloud ecosystems and maintaining data quality

• Familiarity with regulated industries such as finance or banking is preferred

• Demonstrated ability to troubleshoot performance issues and optimize workflows

Day-to-Day Activities

• Develop and maintain data pipelines supporting enterprise analytics and reporting

• Optimize ETL workflows for performance, scalability, and data accuracy

• Collaborate across teams to understand data requirements and implement technical solutions

• Automate data processes and manage infrastructure provisioning using IaC tools

• Monitor data processing jobs, troubleshoot incidents, and perform root cause analysis

• Maintain documentation for data lineage, workflow configurations, and data security

• Support migration and platform upgrade projects ensuring minimal disruption

• Stay updated on new data processing tools, cloud architecture, and compliance standards

Qualifications

• Bachelor’s or Master’s degree in Computer Science, Data Engineering, or related field

• 4+ years managing large-scale data pipelines, preferably in cloud environments

• Experience with Hadoop ecosystem, Spark, and ETL tools in enterprise settings

• Certifications such as AWS Data Analytics, Cloudera, or relevant data platform certifications are advantageous

Professional Competencies

• Strong analytical and troubleshooting skills in data processing contexts

• Excellent collaboration and stakeholder management skills

• Ability to work independently under deadlines and prioritize tasks effectively

• Continuous learning mindset around emerging data, cloud, and AI/ML technologies

• Focus on data quality, security, and scalability to meet industry standards

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