ETL Developer

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.

Responsibilities

Design and execute ETL test scenarios, test cases and test scripts based on business and technical requirements.

Validate source-to-target data mapping, transformation rules, business rules and data flows.

Perform ETL, Data Warehouse and Database Testing across multiple data sources and target systems.

Validate data extraction, transformation, loading and reconciliation processes.

Perform data validation, data completeness, data accuracy and data integrity testing.

Write complex SQL queries for backend data validation, reconciliation and defect analysis.

Validate source-to-target mappings and identify data discrepancies. Perform database testing involving joins, stored procedures, views, functions, indexes and constraints.

Test incremental loads, full loads, CDC and batch processing where applicable.

Validate ETL workflows, schedules, dependencies and error-handling mechanisms.

Perform data reconciliation between source and target systems and investigate mismatches.

Validate duplicate records, missing records, null values, data truncation and transformation errors.

Execute regression, integration, system and end-to-end testing for ETL/data pipelines.

Validate large-volume datasets and perform data quality and consistency checks.

Work with developers, data engineers, business analysts and product teams to resolve data-related issues.

Analyze ETL job failures and assist development teams with root-cause analysis (RCA). Log, track and manage defects using tools such as Jira, Azure DevOps or similar.

Prepare test execution reports, defect reports and testing status updates.

Participate in requirement analysis, test planning, estimation and defect triage meetings.

Support UAT, production validation and post-release data verification.

Ensure testing complies with enterprise data governance, security, privacy and quality standards.

Work in an Agile/Scrum environment and participate in sprint planning, daily stand-ups, reviews and retrospectives.

Collaborate with globally distributed teams and stakeholders across business and technology functions.

Understand insurance-domain data such as policy, customer, claims, billing, premium and financial data is an advantage.

Requirements

4–6 years of hands-on experience in ETL Testing / Data Warehouse Testing / Database Testing.

Strong understanding of ETL concepts, data warehousing and data integration processes.

Strong hands-on SQL skills including complex joins, subqueries, CTEs, aggregations and data reconciliation queries.

Experience with ETL tools such as Informatica, IBM DataStage, SSIS, Talend, Azure Data Factory or similar.

Experience testing large-volume data and enterprise data pipelines. Good understanding of Dimensional Data Modeling, Star Schema, Snowflake Schema, Fact and Dimension tables.

Strong knowledge of source-to-target mapping and transformation validation.

Experience with Oracle, SQL Server, DB2, PostgreSQL or other relational databases.

Knowledge of batch processing, scheduling, incremental/full loads and data migration testing.

Experience with API, web service or downstream application data validation is preferred.

Good understanding of SDLC, STLC, defect lifecycle and Agile methodologies.

Experience with Jira, Azure DevOps, ALM or similar test/defect management tools.

Exposure to cloud data platforms such as Azure/AWS is an added advantage.

Exposure to Python or scripting for test-data validation/automation is desirable.

Knowledge of data quality, reconciliation, data lineage and data governance.

Strong analytical and problem-solving skills with the ability to investigate complex data issues.

Excellent communication and stakeholder-management skills.

Prior experience in Insurance, BFSI or other regulated enterprise environments will be highly preferred.

Job Description:

Skill Set

Informatica, IDMC, Informatica MDM

Experience

4-6 Years

Location

Faridabad, Haryana, India

Work Mode- Hybrid

Job Description

Roles & Responsibilities

• Lead project team members through all activities required to successfully deliver Informatica.
• Define technical specifications for workflows and business rules.
• Prepare detailed design documents for data migration.
• Configure, build and unit test Informatica components, including data structures, roles, workflows, and portals.
• Train and mentor colleagues in Informatica implementation activities and best practices.
• Support integration, system, and user acceptance testing.
• Accountable for the Master Data Management, Technical Architecture, providing data modeling solutions and recommendations.
• Profile & Analyze Source Data usage using ETL tool.
• Automation, job scheduling, dependencies, monitoring.
• Configure/Script Business rules and transformation rules in ETL
• Data pipeline using IICS
• Hands on experience in Informatica MFT, Data Exchange (DX),and Data Transform (DT) modules
• Integration experience using various adapters (MLLP, SOAP, REST, SFTP, ODBC) will be essential.
• Strong knowledge and experience with developing complex SQL Queries, stored procedures, and triggers for RDBMS systems.
• Experience in administering, supporting, and performance tuning using Informatica.

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.

Location – Hyderabad (Hybrid)

Work Experience – 5 to 7 years

CTC – upto 20 LPA

Roles & Responsibilities:

· We are looking for a Senior Data Engineering who will be majorly responsible for designing, building and maintaining ETL/ ELT pipelines.

· Integration of data from multiple sources or vendors to provide the holistic insights from data.

· You are expected to build and manage Data warehouse solutions, designing data models, creating ETL processes, implementing data quality mechanisms etc.

· Performs EDA (exploratory data analysis) required to troubleshoot data related issues and assist in the resolution of data issues.

· Should have experience in client interaction.

· Experience in mentoring juniors and providing required guidance.

Required Technical Skills

· Extensive hands on experience in Python, Pyspark, SQL, Dataiku.

· Strong experience in Data Warehouse, ETL, Data Modelling, building ETL Pipelines, Snowflake database.

· Working knowledge in Databricks, Redshift, ADF etc.

· Hands-on experience in cloud services like Azure, AWS- S3, Glue, Lambda, CloudWatch, Athena.

· Sound knowledge in end-to-end Data management, Data ops, quality and data governance.

· Familiar with SFDC, Waterfall/ Agile methodology.

· Strong domain knowledge in Pharma domain/ life sciences commercial data operations.

Qualifications

· Bachelor’s or master’s Engineering/ MCA or equivalent degree.

· 5-7 years of relevant industry experience as Data Engineer.

· Experience working on Pharma syndicated data such as IQVIA, Veeva, Symphony; Claims, CRM, Sales etc.

· High motivation, good work ethic, maturity, self-organized and personal initiative.

· Ability to work collaboratively and providing the support to the team.

· Excellent written and verbal communication skills.

· Strong analytical and problem-solving skills. 

Job Description

We are looking for an experienced Data Engineer with strong expertise in Python, ETL, SQL, CI/CD, and DevOps to design, develop, and maintain scalable data pipelines and data processing solutions.

Key Responsibilities

• Design, develop, and maintain scalable ETL/ELT data pipelines.
• Develop data processing solutions using Python.
• Write complex and optimized SQL queries, stored procedures, and data transformations.
• Build and maintain data ingestion and integration workflows.
• Implement data quality, validation, monitoring, and error-handling processes.
• Develop and maintain CI/CD pipelines for data engineering applications.
• Work with DevOps tools and practices for automated build, deployment, and infrastructure management.
• Collaborate with data analysts, data scientists, software engineers, and business teams.
• Optimize data pipelines for performance, reliability, and scalability.
• Troubleshoot production data issues and ensure timely resolution.
• Follow best practices for version control, code quality, testing, and deployment.

Mandatory Skills

• Python
• ETL
• SQL
• CI/CD
• DevOps
• Git / Version Control
• Strong problem-solving and debugging skills

Must have experience in Java

Must have experience in Spark

Must have experience in ETL coding

Strong expertise in coding

Hiring for Data Analyst

Exp : 5 - 7 yrs

Edu : BE/B.Tech

Work Location : Noida WFO

Skills :

Expertise in SQL Server, including database design, performance tuning, query optimization, and security.

Hands-on experience developing ETL solutions using SSIS, Azure Data Factory (ADF), and Python.

Job Title: Senior Data Tester

Location : Hyderabad

Mode: Hybrid

Notice Period: Immediate Joiner

Key Responsibilities:

• 8+ years of experience in ETL/data testing.
• Design, implement, and execute data validation test plans and test cases.
• Understanding of data modelling and data governance principles.
• Experience with test automation frameworks and scripting (e.g., Python, Shell)Conduct thorough ETL testing, including data extraction, transformation, and loading.
• Validate data integrity across various sources and destinations (data lakes, warehouses, etc.)
• Perform data reconciliation and analysis to identify inconsistencies or data quality issues.
• Develop and maintain automated data testing frameworks using SQL or scripting languages.
• Strong experience with SQL and writing complex queries for data validation.
• Knowledge of data warehouse concepts and testing tools. Experience with ETL tools (e.g., Informatica, Talend, SSIS, etc.)
• Familiarity with cloud platforms (Azure, GCP) and modern data tools (e.g., Snowflake, Big Query).
• GCP is mandatory. Experience in Agile development and working within cross-functional teams.
• Exposure to BI tools (Power BI, Tableau, Looker)
• Familiarity with CI/CD pipelines and version control systems like Git ISTQB or equivalent testing certifications.

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!