Senior Technical Specialist
Teknik, data och digitalt · Data, AI och analys · Data engineering · Business intelligence · Dataanalys
I korthet
HCLTech is seeking a Senior Technical Specialist in Bangalore, India, to design, develop, and support data integration solutions, focusing on IBM DataStage, data warehousing, and SQL optimization. This role involves collaboration with various teams and adherence to Agile practices.
Ansvarsområden
- Design and develop ETL/ELT solutions using IBM DataStage.
- Build and maintain enterprise data warehouse and data mart solutions.
- Perform dimensional data modeling (Star Schema, Snowflake Schema, Fact/Dimension design).
- Develop and optimize complex SQL queries in Oracle, SQL Server, Teradata, or equivalent platforms.
- Implement data quality controls, reconciliation, validation, and governance standards.
- Develop Python and Shell scripts for automation and operational support.
- Perform performance tuning and troubleshooting of DataStage jobs.
- Integrate deployments with CI/CD pipelines and DevOps practices.
- Provide production support, monitoring, incident analysis, and problem management.
- Collaborate with Business Analysts, Architects, Product Owners, and Data Governance teams.
- Participate in Agile delivery, sprint planning, code reviews, and technical design discussions.
Krav
- Expert hands-on development and support of IBM DataStage.
- Strong architectural and implementation experience in Data Warehousing.
- Proficiency in Dimensional, Logical, and Physical Data Models.
- Advanced SQL skills, including Query Optimization and Performance Tuning.
- End-to-end pipeline development experience in ETL/ELT.
- Experience with DQ Rules, Validation, and Reconciliation for Data Quality.
- Strong operational and scripting knowledge in UNIX/Linux.
- Experience developing Python scripts for automation and data engineering.
- Familiarity with DevOps/CI-CD tools like Git and Azure DevOps.
- Knowledge of Data Governance principles, including Metadata, Lineage, and Controls.
- Experience with banking data, risk controls, and regulatory environments.
- Strong database experience with Oracle, Exadata, or Teradata.
Önskade kvalifikationer
- Preferred experience with BigQuery for Data Engineering on GCP.
- Experience with DBT for modern data transformation.
- Familiarity with Grafana for Monitoring & Observability.
- Experience with ELK Stack for Logging & Analytics.
- Knowledge of SODA for Data Quality Framework.
- Experience with Cloud Platforms such as Azure, AWS, or GCP.
- Familiarity with IBM Information Governance Catalog for Metadata Management.
- Understanding of Data Lake and Modern Data Architecture.
- Experience with Test Automation, TDD, and Validation Frameworks.
- Experience with Risk & Compliance Automation within banking processes.
Förmåner
- Opportunity to work in a global technology company.
- Be part of a team that puts people first.
- Work with clients across major verticals.
- Contribute to industry-leading capabilities in digital, engineering, cloud, and AI.
#DataStage#ETL#Data Warehousing#Data Modeling#SQL#Python#DevOps#Banking
Företag
HCLTech
Publicerade jobb
för 2 veckor sedan
Anställningstyp
Heltid
Arbetsform
På plats
Erfarenhetsnivå
Senior
Platser
Bangalore, India
Sökande
Ansök tidigt