ETL Developer at Synechron · Bengaluru (Bangalore), Hyderabad · 6 - 10 years · ₹2L - ₹15L / yr · Profitable · Posted 12 May 2023

Position: ETL Developer
Location: Mumbai
Exp.Level: 4+ Yrs
Required Skills:
* Strong scripting knowledge such as: Python and Shell
* Strong relational database skills especially with DB2/Sybase
* Create high quality and optimized stored procedures and queries
* Strong with scripting language such as Python and Unix / K-Shell
* Strong knowledge base of relational database performance and tuning such as: proper use of indices, database statistics/reorgs, de-normalization concepts.
* Familiar with lifecycle of a trade and flows of data in an investment banking operation is a plus.
* Experienced in Agile development process
* Java Knowledge is a big plus but not essential
* Experience in delivery of metrics / reporting in an enterprise environment (e.g. demonstrated experience in BI tools such as Business Objects, Tableau, report design & delivery) is a plus
* Experience on ETL processes and tools such as Informatica is a plus. Real time message processing experience is a big plus.
* Good team player; Integrity & ownership

About Synechron
About
Connect with the team
Similar jobs (10)
Strong Senior Developer – PL/SQL, SQL & ETL (Microsoft SSIS) Profile
2
Mandatory (Experience 1) – Must have minimum 5+ years of strong hands-on experience in PL/SQL and SQL development, including complex stored procedures, functions, queries, joins, data manipulation, and query/performance optimization.
3
Mandatory (Experience 2) – Must have strong hands-on experience in ETL development using Microsoft SSIS, including building, maintaining, optimizing, and troubleshooting SSIS packages for large-volume data movement and transformation.
4
Mandatory (Experience 3) – Must have solid experience working with Data Warehousing concepts and architectures, including data models, fact/dimension structures, ETL data flows, and enterprise reporting/data warehouse environments.
5
Mandatory (Experience 4) – Must have experience managing batch jobs, scheduling, and data pipelines, ensuring timely and reliable execution of enterprise ETL workflows.
6
Mandatory (Experience 5) – Must have hands-on experience in production support for SSIS/ETL and data warehouse jobs, including monitoring job execution, troubleshooting failures, performing root cause analysis, and implementing preventive fixes.
7
Mandatory (Experience 6) – Must have experience with data quality, validation, and troubleshooting, including identifying and resolving data discrepancies/issues affecting downstream reports, dashboards, and analytics.
8
Mandatory (Experience 7) – Must have experience with unit, integration, and regression testing of SQL, PL/SQL, and ETL components, along with strong documentation of technical designs, data mappings, data flows, and deployment processes.
9
Mandatory (Location) – Must be willing to work in a hybrid model from a city where Cognizant has an office.
10
Mandatory (Notice Period) – Immediate joiners or candidates who can join within 2–4 weeks.
OBIEE Developer + ETL Lead
🔹 Experience: 8+ Years
🔹 Location: PAN India
🔹 Work Mode: Work From Office – 5 Days
🔹 Joining: Immediate Joiners Preferred
🔹 Communication: Excellent communication skills required
💼 Key Skills:
• #OBIEE Development
• #ETL / #DataIntegration
• #BIReporting & Analytics
• #ETL Lead / Technical Leadership
• Strong #SQL & #Database Concepts
Position: Backup Data ETL Developer
Experience: 6–9 Years
Location: Mumbai
Employment Type: Full-time
Job Description:
We are looking for a Backup Data ETL Developer with 6–9 years of experience in designing, developing, and supporting data extraction, transformation, and loading (ETL) processes.
The candidate should have strong hands-on experience with Hadoop, Spark, Informatica, and Snowflake, along with expertise in large-scale data processing and data integration technologies.
Key Skills:
Hadoop
Spark
Informatica
Snowflake
ETL Development
Data Integration
Data Transformation
Large-Scale Data Processing
ETL Workflows and Data Pipelines
Troubleshooting and Problem-Solving
Strong analytical and collaboration skills
We are hiring an Informatica ETL Developer to build and maintain enterprise data integration pipelines.
Responsibilities
- Develop ETL mappings and workflows in Informatica PowerCenter and IICS
- Build data warehouse loads and transformations
- Tune ETL performance and troubleshoot failures
- Migrate workloads from PowerCenter to IICS
- Document data flows and lineage
Requirements
- 2+ years of Informatica ETL development
- Strong data warehousing concepts
- Exposure to Talend is a plus
Urgent Hiring – Senior Data Engineer
We are hiring for a Senior Data Engineer for a reputed product-based company in Pune.
Location: Pune – Magarpatta / Baner
Experience: 7–10 Years
Work Mode: 5 Days WFO
Notice Period: Immediate to 30 Days preferred
What We're Looking For
- 7+ years of hands-on experience in Data Engineering
- 5+ years of experience in Python
- 4+ years of experience in Snowflake
- 5+ years of experience in SQL
- 5+ years of experience with ADF / Fivetran / Matillion or equivalent Data Integration tools
- Hands-on experience with AWS / Azure
- Experience with Airflow or equivalent orchestration tools
- Strong experience in ETL/ELT and Data Pipelines
- Experience with APIs, JSON, XML and Webhooks
- Knowledge of CI/CD, Git and automated testing
- Exposure to dbt or similar transformation tools
- Experience in data pipeline monitoring, troubleshooting and performance optimization
Key Responsibilities
- Design, develop and maintain scalable ETL/ELT data pipelines
- Build batch, real-time and on-demand data processing workflows
- Integrate data from cloud and on-premise sources
- Ensure data quality, reliability, performance and SLA adherence
- Work closely with Data Scientists, Analysts, DevOps and Business teams
- Implement data engineering best practices, CI/CD and automated testing
- Troubleshoot pipeline issues and perform root cause analysis
- Optimize data pipelines and SQL queries for performance and cost efficiency
Why Join?
- Opportunity to work with a reputed product-based organization
- Work on modern data engineering and cloud technologies
- Exposure to large-scale data platforms and business-critical data solutions
- Collaborative and technically strong environment
Interested candidates can share their updated CV for immediate consideration.
Job Summary
We are looking for an experienced ETL Tester / Data QA Engineer with strong SQL skills to validate data pipelines, ETL processes, data transformations, and data quality across source and target systems. The candidate should have hands-on experience in writing complex SQL queries, performing data validation, and identifying data discrepancies.
Key Responsibilities
- Perform ETL testing for data extraction, transformation, and loading processes.
- Validate data between source and target systems.
- Write and execute complex SQL queries for data validation and reconciliation.
- Verify data transformations, mappings, joins, aggregations, and business rules.
- Perform data completeness, accuracy, consistency, integrity, and duplicate checks.
- Validate incremental and full data loads.
- Test ETL workflows, batch jobs, and data pipelines.
- Identify, document, and track defects using tools such as JIRA.
- Analyze production data issues and support root-cause analysis.
- Prepare test scenarios, test cases, test data, and execution reports.
- Work closely with developers, data engineers, business analysts, and other QA teams.
- Participate in regression, integration, system, and end-to-end testing.
Required Skills
- Strong hands-on experience in ETL/Data Warehouse Testing.
- Advanced SQL skills, including:
- Joins
- Subqueries
- CTEs
- Window functions
- Aggregations
- Stored procedures
- Data reconciliation
- Knowledge of Data Warehousing concepts such as fact and dimension tables, star/snowflake schemas, and slowly changing dimensions (SCD).
- Experience with ETL tools such as Informatica, Talend, SSIS, DataStage, or similar.
- Experience with relational databases such as Oracle, SQL Server, PostgreSQL, or MySQL.
- Good understanding of SDLC/STLC and defect life cycle.
- Experience with Agile/Scrum methodologies.
Good to Have
- Experience with cloud data platforms such as Snowflake, AWS, Azure, or GCP.
- Knowledge of tools such as Databricks, Azure Data Factory, AWS Glue, or dbt.
- Experience with API testing or data pipeline automation.
- Basic knowledge of Python for test/data validation automation.
- Experience testing large-volume datasets and complex data migrations.
Qualifications
- Bachelor's degree in Computer Science, IT, Engineering, or a related field.
- Strong analytical and problem-solving skills.
- Good communication and documentation skills.
We are looking for an MSBI Developer to build ETL and reporting solutions on the Microsoft BI stack.
Responsibilities
- Build ETL packages in SSIS
- Create reports in SSRS and cubes in SSAS
- Write and optimise T-SQL queries and stored procedures
- Maintain the data warehouse and its data quality
Requirements
- 2+ years with SSIS and SQL Server
- Good T-SQL and data warehousing skills
- SSRS or SSAS experience
Job Summary
Role Overview
We are looking for an experienced Data Engineer with strong expertise in Python, ETL, Advanced SQL, CI/CD, DevOps, and Data Analytics. The ideal candidate should have hands-on experience designing and developing scalable data pipelines, transforming large datasets, and supporting data-driven applications.
Experience with Google Cloud Platform (GCP) will be an added advantage.
Key Responsibilities
- Design, develop, and maintain scalable ETL/ELT data pipelines using Python and SQL.
- Develop complex and optimized SQL queries, stored procedures, and data transformations.
- Build and maintain reliable data integration workflows across multiple data sources.
- Perform data cleansing, validation, transformation, and quality checks.
- Analyze data and provide insights to support business and technical requirements.
- Implement and maintain CI/CD pipelines for data engineering applications.
- Work with DevOps practices and tools to automate deployments, monitoring, and infrastructure processes.
- Troubleshoot data pipeline failures, performance issues, and production incidents.
- Optimize data processing workflows for performance, scalability, and reliability.
- Collaborate with Data Analysts, Data Scientists, Developers, and other stakeholders.
- Follow best practices for version control, testing, documentation, and deployment.
- Contribute to cloud-based data engineering initiatives, preferably on GCP.
Required Skills
- 5–7 years of hands-on experience in Data Engineering.
- Strong programming skills in Python.
- Strong expertise in Advanced SQL and database concepts.
- Hands-on experience with ETL/ELT processes and data pipelines.
- Good understanding of Data Warehousing and Data Modeling concepts.
- Experience with CI/CD practices and tools.
- Strong understanding of DevOps principles, automation, and deployment processes.
- Strong data analytics and problem-solving skills.
- Experience working with large datasets and performance optimization.
- Good understanding of Git/version control and software development best practices.
Good to Have
- Hands-on experience with Google Cloud Platform (GCP).
- Exposure to GCP data services such as BigQuery, Cloud Storage, Dataflow, Composer, or Pub/Sub.
- Experience with containerization/orchestration technologies such as Docker/Kubernetes.
- Experience with workflow orchestration tools such as Airflow.
- Knowledge of cloud-based data architecture and distributed data processing.
Preferred Candidate Profile
- Strong analytical and problem-solving abilities.
- Good communication and stakeholder management skills.
- Ability to work independently as well as in a collaborative team environment.
- Strong ownership of data pipelines and production systems.
- Candidates who can join at short notice are preferred.
Mandatory Skills
Data Engineer, Python , ETL, GCP, Advanced SQL, Strong Data Analytics skills, CICD, Devops
Role Overview
We are seeking a skilled Senior Data Analyst with substantial hands-on experience in Source System Analysis, data mapping, data modeling, SQL analysis, and integration testing. The ideal candidate will support seamless data flow across business applications, ensure data accuracy, and contribute to system improvements.
Key Responsibilities
- Conduct detailed data mapping between source and target systems, ensuring consistency and accuracy.
- Build and maintain data models to support business processes, reporting needs, and integration workflows.
- Write and optimize SQL queries for data validation, analysis, migration, and troubleshooting.
- Work closely with cross-functional teams to gather data requirements and understand business logic.
- Develop and execute integration test plans, including functional, data validation, and regression testing.
- Support data migration activities, including extraction, transformation, and loading (ETL).
- Monitor and troubleshoot integration issues, ensuring timely resolution.
- Document integration flows, data dictionaries, mapping catalogs, and knowledge artifacts.
- Ensure integration security, data integrity, and compliance with organizational standards.
Required Skills & Qualifications
- 5+ years of experience insource system integrations, data mapping, and system-to-system data workflows.
- Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field.
- Hands-on experience with data mapping, data modelling, and database schema design.
- Proficiency in SQL (complex joins, stored procedures, performance tuning).
- Experience with ETL tools or integration platforms (Informatica, Boomi, MuleSoft, Talend, Pentaho).
- Strong analytical and problem-solving skills.
- Experience with API-based integrations (REST/SOAP) is a plus.
- Familiarity with testing methodologies for integrations and data validation.
- Ability to work with business users, understand workflows, and translate requirements into technical solutions.
Preferred Qualifications
- Experience with cloud ERP or cloud integration (AWS/Azure/GCP).
- Knowledge of JSON, XML, CSV transformation.
- Exposure to scripting languages (Python, Shell).
- Experience in Agile/Scrum environments.
- Prior involvement in ERP implementation or upgrade projects.
Competencies
- Tech Savvy - Anticipating and adopting innovations in business-building digital and technology applications.
- Self-Development - Actively seeking new ways to grow and be challenged using both formal and informal development channels.
- Action Oriented - Taking on new opportunities and tough challenges with a sense of urgency, high energy, and enthusiasm.
- Customer Focus - Building strong customer relationships and delivering customer-centric solutions.
- Optimize Work Processes - Knowing the most effective and efficient processes to get things done, with a focus on continuous improvement.
Why Join Us?
- Be part of a collaborative and agile team driving cutting-edge AI and data engineering solutions.
- Work on impactful projects that make a difference across industries.
- Opportunities for professional growth and continuous learning.
- Competitive salary and benefits package.
Application Details
Ready to make an impact? Apply today and become part of the QX Impact team!
Position title: Business Intelligence and Data Analyst
Summary -
• Operate and continuously improve the CARS/BI backend within the global Enterprise Data and Business Intelligence platform, ensuring system stability, continuous data loading, and Warehouse the timely delivery of business-critical reports.
• Own the underlying data foundation — SQL pipelines, relational data models, and data warehouse structures — that internal reporting teams and global Data Management initiatives depend on, and act as 1st and 2nd level support for internal customers such as SCM and Sales.
• The role is needed to secure daily BI availability in the Asian time zone, reduce the risk of late or incorrect reporting, and add dedicated database and ETL capacity to the global BI team, including support to the Data Centre team on infrastructure-related issues.
Responsibilities:
• Operate, monitor, and maintain the CARS/BI data integration and data processing workflows, ensuring continuous data loading and stable daily business operations.
• Provide 1st and 2nd level support for CARS/BI, including user support, incident handling, and root-cause analysis of data issues.
• Develop, maintain, and optimise SQL-based data pipelines and transformations within the Enterprise Data Warehouse.
• Design and maintain relational data models and data warehouse structures for CARS BI.
• Integrate data from ERP and other enterprise systems into the BI backend.
• Ensure data consistency, integrity, and performance at the database level, including query tuning and database efficiency improvements.
• Administer the BI technical environment and contribute to its continuous enhancement as part of a global team.
• Support reporting teams by providing structured, reliable datasets and safeguarding the timely delivery of business-critical reports.
• Contribute to global Data Management initiatives, with a focus on Master Data Management and the development of a Common Data Model within the Business Integration Platform.
• Collaborate with the Data Centre team to resolve infrastructure-related issues affecting BI availability.
Education and Experience:
Bachelor's degree in Engineering (BE/B.Tech) or equivalent in Computer Science, Information Technology, or a comparable technical field.
Minimum 3 years of relevant professional experience in Business Intelligence, data warehousing, or database development, including hands-on SQL and ETL work in an enterprise environment.
Experience supporting business users in a global or multi-time-zone IT organisation is an advantage.
Competencies:
• Knowledge about either BI platforms (e.g. IBM Cognos BI suite) or ETL tools (e.g. Informatica PowerCenter)
• Database, data modeling and SQL (preferred Oracle PLSQL)
• Good analytical and communication skills
• Teamplayer
• English
• Strong hands-on experience with SQL (advanced level)
• Solid understanding of relational databases and data warehouse concepts
• Experience with ETL tools and database technologies (e.g., Oracle, SQL Server, SAP BW,Informatica or similar)
• Performance tuning and query optimization skills
• Structured, detail-oriented, and quality-focused working style
• Good understanding of enterprise data flows (SAP/CARS is a plus)
Key Interfaces and Stakeholders:
Only internal customers with different topics: e.g. SCM, Sales etc.
Geography to cover and Travel requirements:
Asian Time Zone, Sometimes travel is required
Behavioral Characteristics
Reliability and accountability — the role safeguards daily reporting availability, so dependable ownership of monitoring and issue follow-up is expected. Structured, analytical problem solving with the patience for thorough root-cause analysis. Service orientation and clear communication towards internal customers such as SCM and Sales. Initiative taking and self-reliance, given largely independent work in the Asian time zone. Cooperation and team spirit within a globally distributed BI team across cultures and time zones. Flexibility and resilience under time pressure, including occasional off-hours support during critical data loads. Integrity and discretion when handling confidential business data. Quality focus and attention to detail, with a continuous improvement mindset.
Interview process
2 rounds - Virtual interview and 1 round Face to Face
Any other Criteria
- Notice Period: Below 60 or 90 Days . No Negotiation on Notice Period
- Gender: Female and Male; Female preferred
- Qualification:Bachelor's degree in Engineering (BE/B.Tech) or equivalent in Computer Science, Information Technology,






