
About the Role
- Design and develop ETL processes using Informatica IICS / Informatica Powercenter.
- Collaborate with stakeholders to gather requirements and translate them into technical specifications.
- Should have good expertise on IICS Data integration / Informatica Powercenter and Application
Integration, Oracle SQL
- Implement data integration solutions that ensure data accuracy and consistency.
- Monitor and optimize existing workflows for performance and efficiency.
- Troubleshoot and resolve any issues related to data integration and ETL processes.
- Maintain documentation for data processes and integration workflows.
#Sectoral Skills:
Petroleum products/ Transport fuels/ Mobility/ Fuel retail/ Non-fuel retail or forecourt management,
Lubricants, LPG, LNG, CNG OR Refinery process knowhow/ Operational technology/ Project & pipeline
management/ LNG shipping-trading-liquefactionregassification-marketing/ Terminal-depot management
OR
Exploration & Production/ Oilfield services & equipment understanding/ Geological/ Geophysical/
Reservoir knowhow and data assessment/ Extraction/ Processing / Enhanced Oil Recovery OR Biofuels/
Ethanol/ Biodiesel/ SAF/ Biogas/ Green Hydrogen/ Green Ammonia/ Green Methanol/ Petrochemicals/
CCUS
Functional: Transformation experience/ Digital transformation/Profitability improvement/ Performance
improvement/ Cost takeout/ Business process re-engineering/ Process design/ Supply chain assessment
& redesign/ Logistics network assessment and planning/ Branding & Marketing strategy/ Go-to-market
strategy/ Sales & distribution redesign/ Channel strategy & restructuring/ Decarbonization/ Net-zero
strategy/ Business planning/ Financial modeling OR Digital maturity assessment/ BRD/ FRD
development/ Business requirement gathering/ Business analysis/ Customer-MarketingSales analytics/
Operational analytics/ Supply chain analytics/ Understanding of technology ecosystem and vendors
(OEMs/ hyperscalars/ startups etc.) in above mentioned areas
Requirements
Mandatory skill sets:
ETL Informatica Preferred skill sets:
ETL Informatica Years of experience required:
4+ Education qualification:
BTech/MBA/MCA #Responsibilities:
Possess hands-on experience in IICS / Informatica Powercenter.
Demonstrated involvement in end-to-end IICS/IDMC project.
Possess hands-on experience in Informatica PowerCenter
Structured Query Language (SQL)
Data Warehouse expertise
Experience in Extract, Transform, Load (ETL) Testing
Effective communication skillsÂ
Mandatory skill sets:
Consulting background, Petroleum products, Transport fuels/ Mobility, Fuel retail/ Non-fuel retail or forecourt management, Refinery process know how/ Operational technology, Lubricants, LPG, LNG, CNG, Oilfield services & equipment, Enhanced Oil Recovery, DownstreamÂ
Preferred skill sets:
Use feedback and reflection to develop self awareness, personal strengths and address development areas.
Delegate to others to provide stretch opportunities, coaching them to deliver results. · Demonstrate critical thinking and the ability to bring order to unstructured problems.
Use a broad range of tools and techniques to extract insights from current industry or sector trends.Â