Senior Data Engineer (IBM DataStage, ETL, SQL/PLSQL)_6+Yrs_Pune/Bangalore/Indore
Total System Services, LLC (TSYS)17 days ago
Pune, India +2 moreSenior
Responsibilities
- Design, develop, test, deploy, and support scalable IBM DataStage ETL solutions and enterprise data pipelines.
- Build Snowflake pipelines, data transformations, semantic models, Cortex AI solutions, data quality validations, and reporting datasets.
- Develop reusable, parameterized, and metadata-driven ETL frameworks and automated data processing workflows.
- Implement data extraction, transformation, validation, cleansing, reconciliation, and loading processes.
- Design data models, semantic views, APIs, source-to-target mappings, governance requirements, and scalable data integration solutions.
- Optimize data movement, performance, scalability, reliability, and security across data warehouse, data lake, and Lakehouse platforms.
- Collaborate with product managers, analysts, business stakeholders, architects, and technology teams to translate requirements into technical solutions.
Requirements
- 6+ years of experience is indicated by the job title.
- Strong hands-on experience with IBM DataStage 11.7 or above, including parallel jobs, sequencers, parameter sets, job monitoring, administration, and performance tuning.
- Advanced SQL and PL/SQL development skills with strong experience in Oracle and DB2 environments.
- Experience designing and implementing complex ETL/ELT solutions and enterprise data pipelines.
- Experience integrating Oracle, DB2, SQL Server, Snowflake, flat files, XML, JSON, Parquet, and cloud storage platforms using DataStage.
- Experience working with structured, semi-structured, and unstructured data sources.
- Experience with payments processing and sensitive data such as PCI and PII is a bonus.
- Experience with Airflow or Astronomer and Unix Shell Scripting is expected.
- Experience with Agile Framework for delivering projects is a bonus.
Tech Stack
Categories
Data Engineering