Technical Lead (IN)
HCLTech
HCLTech
We are seeking a seasoned DataStage Engineer with extensive experience in ETL development and data warehousing. The ideal candidate will lead the design, development, and support of enterprise-scale ETL solutions, demonstrating strong technical leadership and the ability to work across diverse business domains. This role requires a proactive approach to delivering high-quality data integration outcomes.
Key responsibilities include designing, developing, testing, and deploying robust ETL solutions using IBM DataStage. This involves translating business requirements into scalable ETL designs, optimizing complex workflows, and working on projects within various domains like Banking and Finance. The role also entails leading development teams, mentoring junior members, conducting code reviews, and ensuring adherence to development standards. Collaboration with business analysts, architects, DBAs, and stakeholders is crucial. Responsibilities extend to troubleshooting production issues, implementing data quality measures, participating in architectural discussions, and optimizing ETL jobs and SQL queries for peak performance and scalability.
Essential skills include strong hands-on experience with IBM DataStage, covering features like Parallel Jobs, Sequence Jobs, Shared Containers, Job Sequencing, Change Data Capture (CDC), performance tuning, and troubleshooting. Proficiency in multiple RDBMS platforms such as Oracle, SQL Server, and PostgreSQL is required, along with the ability to write complex SQL queries. A solid understanding of ETL/ELT concepts, data warehousing architecture, and data modeling is fundamental. Preferred experience includes other ETL tools like Informatica PowerCenter, SSIS, Talend, or Azure Data Factory. Nice-to-have skills encompass cloud data platforms (Azure, AWS, GCP), Databricks, Spark, Hadoop, DevOps/CI-CD for ETL, and an IBM DataStage certification. Knowledge of Data Quality Frameworks, Metadata Management, and Data Governance concepts is also beneficial.
HCLTech
IT Consulting