DATA ENGINEER- ETL (ODI) Data Integration, Data Modeling, Snowflake Platform( Preferable)




  • SQL, PLSQL and Data Modelling
  • ETL (ODI) and Data Integration
  • Performance Tuning and Optimization
  • Cloud Computing (AWS)
  • Data Warehousing, Business Intelligence & Data Migration Concepts
  • Scripting Language (Python, Bash)
  • Hands on experience good to have in SNOWFLAKE Platform (Preferable)


  • Attention to Detail
  • Problem Solving
  • Time Management
  • Customer Handling
  • Flexibility for Teamwork
  • Critical Thinking & Leadership quality

Experience Details –

  • ODI consultant with overall experience of 4-5 years of relevant experience in the implementation using ODI.
  • Minimum 4-5 years of end-to-end DWH Implementation experience.
  • Good to have 2-3 years of end-to-end Snowflake Design and Development experience.

Job Descriptions –

  • Should have experience in developing ETL processes – ETL control tables, error logging, auditing, data quality, etc.
  • Should be able to implement reusability, parameterization, workflow design, etc.
  • Knowledge of ODI Master & work repository & customization of KM as per requirements
  • Should have strong design & development skills.
  • Ability to design & develop Interfaces, Packages, Load plans, user functions, variables & sequences in ODI.
  • Understanding of ODI/ODQ administration, maintenance & configuration skills.
  • Experience working with multiple source/target systems such as Oracle, MS SQL Server, XML files, flat files, MS access/excel documents.
  • Design and develop complex mappings, Process Flows and ETL scripts
  • Exposure to Data warehouse, Data mart development, Fact & Dimensional DB designs.
  • Experience in high data volume environments/ performance tuning in ODI.
  • Integrate ODI with multiple Source / Target, configure Standalone & Java EE agents
  • Must be well versed and hands-on in using and customizing Knowledge Modules (KM)
  • Good to have exposure on ODI Administration & Load Balancing.
  • Should be able to configure topology and CDC / Journalizing implementations for all the technologies.
  • Experience in Modelling (logical & Physical) Marts, Strong database design, relational & dimensional modelling.
  • Experience of creating PL/SQL packages, procedures, Functions, Triggers, views, Mat Views and exception handling for retrieving, manipulating, checking and migrating complex datasets in oracle and complex queries
  • Experience in SQL tuning and optimization using explain plan and SQL trace files.
  • Partitioning and Indexing strategy for optimal performance
  • Ability to work with minimal guidance or supervision in a time critical environment.
  • Experience in understanding complex source system data structures preferably in Telecom Industry
  • Should have experience of interacting with customers in understanding business requirement documents and translating them into ETL specifications and High- and Low-level design documents.
  • Design and develop data models and data warehouses in Snowflake
  • Develop and maintain ETL processes to move data from source systems to Snowflake
  • Create and maintain views, stored procedures, and other database objects
  • Troubleshoot and debug data issues maintaining Issue Tracker monitoring process
  • Must have strong experience in SQL, stored procedures, ELT in Snowflake Environment.
  • Design, develop, test, deploy, and maintain enterprise-level applications using the Snowflake platform
  • Develop and maintain data pipelines and data integration processes
  • Develop and maintain data quality, data governance, DW automation processes
  • Develop and maintain DW reporting, analytics, monitoring, alerting solutions with Backup and Recovery
Job Category: Development
Job Type: Full Time
Job Location: Kolkata
Experience: 5-7 Years

Apply for this position

Allowed Type(s): .pdf, .doc, .docx