Chat

iimjobs

jobseeker Logo
Now Apply on the Go!
Download iimjobs Jobseeker App and get a seamless experience for your job-hunting
30/09 Ramji K Sakpal
Senior HR Consultant at Live Connections

Views:103 Applications:22 Rec. Actions:Recruiter Actions:7

Manager - Data Integration Architecture - KPO/Research (15-22 yrs)

Any Location Job Code: 852642

Job Description :


- Oversees and designs the information architecture for the data warehouse, including all information structures i.e. staging area, data warehouse, data marts, operational data stores, oversees standardization of data definition, Oversees development of Physical and Logical modelling.


- Deep understanding in Data Warehousing, Enterprise Architectures, Dimensional Modelling, Star & Snow-flake schema design, Reference DW Architectures, ETL Architect, ETL (Extract, Transform, Load), Data Analysis, Data Conversion, Transformation, Database Design, Data Warehouse Optimization, Data Mart Development, and Enterprise Data Warehouse Maintenance and Support etc.

- Good Presales experience and expertise in DWBI solutions and proposal building

- Inventories existing data design, including data flows and systems, Designs data Model that integrates new and existing environment, Develops

- Consults with business on low to moderately complex business needs

- Evaluates moderately complex requirements and creates detailed business requirements and technical specifications. Analyses impact to other reports and Solves moderately complex business and system issues

- Participates in creation of test cases and executes basic test plans & Creates individual task estimates

- Conducts architecture meetings with Team leads and Solution Architects to communicate complex ideas, issues, and system processes along with Architecture discussions in their current projects

- Ready to work at client side, conduct Proof of concepts and demonstrate the solution capability

- Minimum 13 to 15 years of IT experience with 6+ years of Data Modelling experience in Data Warehouse as a Data Model/Architect

- Expertise in Logical, Physical & Dimensional Modelling. Develop and maintain conceptual, logical, and physical data modelling in a relation database, Big data, in-memory and MPP architectures.

- Maintain in-depth and current knowledge of the Cloud architecture, Data lake, Data warehouse, BI platform, Platform to develop and deploy advanced analytics models and ETL tools

- Good experience in Data Profiling & Data Analysis of discrete source and target systems

- Good experience of using any one Data Modelling tool like Erwin, Power Designer, ER Studio

- Experience of using any ETL Tool (Informatica, Data Stage PL/SQL) - Primary - Informatica/Data Stage

- Perform any of the following as needed: requirement analysis, data profiling, effort estimation for database and data warehouse design and development.

- Provide thought leadership around the use of industry standard tools and models (including commercially available models and tools) by leveraging experience and current industry trends.

- Provide guidance on the creation and best practices around Data Governance, Data Stewardship and overall Data Quality initiatives and processes as part of the overall data effort.

- Strong database knowledge and expertise in SQL

- Should have played the role of Data Modeller/Architect in large Warehouse projects with complex business requirements

- 5+ years working as a Data Architect with depth in data integration and data architecture for Enterprise Data Warehouse implementations (conceptual, logical, physical & dimensional models).

This job opening was posted long time back. It may not be active. Nor was it removed by the recruiter. Please use your discretion.

Women-friendly workplace:

Maternity and Paternity Benefits

Add a note
Something suspicious? Report this job posting.