Job Description

Hi
Greetings of the Day.
We have a critical opening with our client for the Data Engineer for Pan India Location.
Experience : 5-12 years - New Delhi/ Work from Home
Payroll Company Name: CIEL
Mode of Employment: Contract
Notice Period :Immediate, 15 days & 30 days Max
Job description
Key Responsibilities:
Develop and maintain ETL jobs using Talend Data Integration suite for batch and real-time data processing.
Write and optimize complex SQL scripts, queries, and analytical functions for data transformation and validation.
Recreate, enhance, and troubleshoot stored procedures, functions, and packages in Oracle and Vertica environments.
Perform impact analysis and data lineage tracking for changes in source systems and downstream dependencies.
Migrate legacy ETL workflows and SQL logic to Talend-based frameworks.
Implement data quality and data profiling checks to ensure reliability and accuracy of ingested data.
Support data reconciliation and validation efforts between source and target systems.
Collaborate with DBAs and infrastructure teams to optimize data storage, indexing, and partitioning strategies.
To participate in code reviews, version control, and deployment automation for ETL scripts and database code.
Troubleshoot and resolve production data issues and support root cause analysis.
Education and Certifications:
Mandatory - Bachelor's degree (B.Tech /B.E.)
Technical Skills, Knowledge & Abilities
Proficient in using Talend ETL suite for data integration and transformation.
Deep working knowledge of Oracle, Microsoft SQL Server, and PostgreSQL databases.
Exposure to Vertica as a data warehouse solution.
Expertise in SQL query development for data extraction, manipulation, and analysis.
Solid understanding of designing and maintaining stored procedures across multiple RDBMS.
Knowledge of data security, integration, and interoperability best practices in data engineering.
Familiarity with data warehousing concepts, including OLAP and data cubes.
Experience with metadata management and implementing data quality frameworks.
Programming skills in Python, SQL, or Java for building data workflows and automation scripts.
Work Experience:
5-10 years of relevant experience About CIEL HR (Payroll Company)
Ciel HR marks the return of HR visionaries to the HR Services industry, powered by technology and analytics. The Founders of Ma Foi, the pioneer of the HR services sector in India, along with some of the finest brains in the HR Services Industry have envisioned and built the firm, CielHR, to deliver the full range of Recruiting services from Executive Search, Recruitment Process Outsourcing and Staffing Permanent as well as Temporary roles through its offices in India and the Middle East.
Website:
Role really excites you kindly share resume to
Regards
Manopriya T S
CIEL HR