Nice Software Solutions - ETL Lead - Talend/Datastage

Description : Data Engineering SME Talend / Datastage / Oracle / Cloudera. Experience 10+ Years.

Job Description :

We are looking for a highly skilled Data Engineering SME with deep expertise in Talend or Datastage, strong hands-on experience in Oracle or Cloudera/Hadoop ecosystems, and excellent SQL & data engineering skills. The ideal candidate will play a key role in designing, building, optimizing, and supporting enterprise-grade data pipelines and data integration solutions.

Key Responsibilities :

Data Engineering & ETL Development :

- Build scalable data integration workflows for batch and real-time data processing.

- Implement transformation logic, error handling, performance tuning, and reusable ETL frameworks.

- Drive migration and modernization of existing ETL processes to Talend, Datastage, or Cloudera platforms.

Data Platform Expertise :

- Work with Oracle PL/SQL, partitions, indexes, stored procedures, and query optimization.

- Hands-on experience with Hadoop components such as HDFS, Hive, Impala, Spark (optional but preferred).

- Support end-to-end data lifecycle including ingestion, transformation, storage, and delivery.

SQL & Data Modeling :

- Write advanced SQL for complex transformations, data validation, profiling, and analysis.

- Build logical and physical data models aligned with business requirements.

- Perform data quality checks, root cause analysis, and impact assessments.

- Ensure data accuracy, completeness, and consistency across systems.

Solution Design & SME Role :

- Act as the Subject Matter Expert for all ETL/data engineering design decisions.

- Provide best practices, standards, and architectural guidance on data integration.

- Collaborate with cross-functional teams including BI, Analytics, Product, and Platform groups.

- Review team deliverables and ensure technical quality and performance.

- Support production systems, troubleshoot failures, and ensure high availability.

Testing & Documentation :

- Ensure detailed documentation for data flows, mappings, and ETL processes.

- Create operational guides, SOPs, and knowledge-sharing collateral for the team.

Required Skills & Experience :

Technical Skills :

- Strong experience in Oracle (PL/SQL, performance tuning) or Cloudera/Hadoop.

- Deep understanding of ETL frameworks, data warehousing, data pipelines.

- Strong SQL skills joins, window functions, analytical queries, optimization.

- Experience with data modeling, data quality, and metadata management.

- Familiarity with UNIX/Linux scripting, job scheduling, and automation tools.

Nice-to-Have :

- Experience with Spark, Kafka, or Python.

- Knowledge of CI/CD, version control, and DevOps practices.