Job Role: Senior Technical Consultant – ODI, Data Warehousing & SQL
Shift: UK Shift (2.00 PM to 11.00 PM)
Work Mode: Hybrid
Relevant Exp: 9+ Years
Location: Pune, Noida, Chennai
Job Description:
Job summary
Skilled BI developer/Data Engineer with extensive hands-on experience on the listed tools/technologies and is comfortable working across the full data lifecycle - from raw ingestion to reporting and visualization
Must Have: ODI, SQL/PL-SQL, Data Warehousing (EDW/ODS), ETL/ELT, Data Modeling, Oracle Database
Preferred: Oracle Fusion Cloud/Oracle EBS, Power BI, Microsoft Fabric, Snowflake, Kafka
Key Responsibilities
Strong understanding of Data warehouse concepts
Extensive development experience in ODI to Extract/Load/Transform data from multiple sources such as Oracle, MS SQL Server, DB2, Legacy systems, Flat Files, JSON and XML Files into ODS and EDW (Enterprise Data Warehouse) systems
Design, develop, and maintain ETL/ELT pipelines using Oracle Data Integrator (ODI), including load plan packages, scenarios, and executions
Build and optimize SQL/PLSQL transformations, views, packages, and stored procedures in Oracle DB
Integrate data from REST APIs and JSON sources into the data pipeline
Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modelling like Dimensional Data Modelling, Star Schema Modelling, Snow-Flake Modelling, FACT and Dimensions Tables using Analysis Services.
Lakehouse/Warehouse management
Excellent spoken/written English and communication / documentation skills
Willingness to learn new things at a fast pace
Sincerely adheres to standards published by the client and follows instructions to the
Very good team player with excellent collaboration skills.
DevOps & Collaboration
Use Azure DevOps and Git for source control, pull request (PR) creation and approval, and deployment pipeline management
Perform data validation, testing, and deployment across environments
Collaborate with data architects, analysts, and business stakeholders to understand requirements and deliver quality solutions
Leverage AI tools to improve development productivity and efficiency
Nice to Have:
Experience with Oracle Fusion Cloud / EBS
Power BI, Microsoft Fabric, Kafka, and Snowflake.