Senior Technical Consultant - ODI, Data Warehousing & SQL - 10929

Job description

Job Description Senior Technical Consultant - ODI, Data Warehousing & SQL - 10929 Job Location: Pune Location Flexibility: Multiple Locations in Country Req Id: 10929 Posting Start Date: 8/5/26 At Fujitsu, our purpose is to make the world more sustainable by building trust in society through innovation. Founded in Japan in 1935, Fujitsu has been a pioneer in technology and innovation for decades. Today, as a world-leading digital transformation partner, we are committed to transforming business and society in the digital age. With approximately 130,000 employees across over 50 countries, Fujitsu offers a broad range of products, services, and solutions. We collaborate with our customers to co-create solutions that drive enterprise-wide digitalization while actively working to address social issues and contribute to the United Nations Sustainable Development Goals (SDGs). 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. Relocation Supported: Yes Visa Sponsorship Approved: No At Fujitsu, we are committed to an inclusive recruitment process that values the diverse backgrounds and experiences of all applicants. We believe that hiring people from a wide variety of backgrounds makes us stronger, not because it's the right thing to do, but because it allows us to draw on a wider range of perspectives and life experiences.