We are looking for an experienced DataStage Designer / ETL professional to design, develop, enhance, and support enterprise data integration solutions. The role requires strong hands-on experience in IBM DataStage, SQL, database technologies, ETL design, troubleshooting, and data validation.
Design, develop, test, and maintain IBM DataStage ETL jobs for enterprise data integration.Develop ETL workflows for extracting, transforming, and loading data across heterogeneous source and target systems.Analyze source-to-target mappings and translate business/data requirements into scalable ETL solutions.Develop and optimize complex SQL queries, stored procedures, and database operations.Perform data validation, reconciliation, troubleshooting, and root-cause analysis for data/ETL issues.Optimize DataStage jobs for performance, reliability, restartability, and efficient batch processing.Support production deployments, defect resolution, and batch/job failures.Work closely with data architects, developers, testers, and business stakeholders.Conduct technical reviews and provide guidance to junior team members.Follow coding standards, version-control practices, and release/deployment processes.
Strong hands-on expertise in IBM InfoSphere DataStage / DataStage DesignerETL design and developmentStrong SQL and relational database knowledgeExperience with databases such as Oracle and MS SQL ServerData mapping, transformation, validation, and reconciliationData Warehouse / Data Integration conceptsPerformance tuning and ETL troubleshootingUnix/Linux and shell scripting knowledgeStrong analytical and problem-solving capability
Informatica or another enterprise ETL platformControl-M or equivalent batch scheduling toolsHadoop / big-data ecosystem exposureCloud data platforms such as Azure, AWS, or GCPBanking / Financial Services domain experienceData migration and large-volume data-processing experience
HCLTech is a global technology company, home to more than 226,600 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending September 2025 totaled $14.2 billion. To learn how we can supercharge progress for you, visit hcltech.com.
