- Lead and guide in design and development of Informatica / Pentaho based ETL Architecture
- Architect, Manage, build and quality assure code to ensure fulfillment of business requirement and adhering to ETL architecture and ensure inconsistency, data redundancy and duplication of objects are eliminated
- Manage partners to handle various layer of Data Warehousing like Database Management, Data Extraction, Transformation and Loading (ETL), Integration for souring the data from various operational systems, Design, build and launch new data models
- Assess requirements for completeness and accuracy.
- Determine if requirements are actionable for ETL team.
- Conduct impact assessment and determine size of effort based on requirements.
- Develop full SDLC project plans to implement ETL solution and identify resource requirements.
- Experience in agile methodologies
- Define and manage SLAs for all ETL jobs, reports and analytics and support all existing ETL and data quality processes running in production
- Build data expertise and own data quality
- Exercise creativity in the design, development, or improvement of existing processes and driving management of change
- Manage and implement on-going operations of hosted data solutions including security, user admin, and other administrative requirements
Function
Information Technology
Reporting To
DGM - Data Warehouse and ETL
Essential Attributes
Experience in Data Warehouse designing (on-prem and Cloud), Experience in databases like SQL Server, Oracle Cosmos etc. Experience in ETL tools like SSIS etc.
Desired Attributes
Experience in integrating with Sales Force, Power BI or similar visualization tools, Experience in Jira or ServiceNow or similar tools
Qualification
Graduation in Engineering (preferably in Computer Science
Desired Experience(years)
10+ Years in Developing Data Warehouse solution
Skills Required
Informatica, Information Technology, Data Warehousing, Oracle, Ssis, Sdlc