- This role is for a Technical Consultant who can understand and solves complex functional, technical, and architectural issues around data integration and has the ability to understand the implications associated with the chosen technical strategy well aligned with the business context
- The successful candidate will be expected to interact with all levels of the business and technical community, seeking approval from all stakeholders of the projects
- The candidate should be expert in ETL architecture & design as well as in data modelling, while demonstrating a keenness to master, suggest and work with different technologies & toolsets
- The candidate is also expected to be hands-on on coding, so as to be effective reviewer as well to develop complex scenarios
- The role would also involve intensive interaction with the business and other systems groups, so good communications skills and the ability to work under pressure are absolute must

Experience and Qualifications Required
- B.E./ B.Tech / MCA, FULL time course only
- 10-14 years of overall IT experience.

Essential Skills:




- Architecting, Planning and Implementation of end-to-end Data Warehouse and Business Intelligence systems utilizing best practices from Data Architecture, Data Integration and Data Management areas.
- Expert Data Modeling skills: entity-relationship as well as dimensional, design experience of staging area, data warehouses, data marts and ODS, at least 4+ years
- Data Analysis, Source System Analysis and Data Mapping to Target Data Model
- Extensive knowledge in in Data Integration architecture / ETL / Data warehouse, esp large and complex data warehouses, at least 8+ years
- Strong experience in SQL and PL/SQL and Informatica Powercenter and performance improvements techniques across ETL technology stack, at least 6+ years. The candidate must be hands-on on these technologies
- Valuable experience with Oracle 11g/12c databases including thorough understanding of Partitioning, Indexing, Arch

📌 Etl Architect (Gurugram)
🏢 Augusta Infotech
📍 Gurugram