top of page

IN_Senior Associate_ ETL Informatica _D&A_Advisory

Mumbai, Maharashtra, India

Job Type

Senior Associate

Workspace

Onsite : 583228WD

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. 

bottom of page