HARD SKILLS & CAPABILITIES –
- 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)
SOFT SKILLS & COMPETENCIES –
- 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