Search Jobs

10+ yrs - Data Modeler - Bangalore

Required Skills:

  Informatica
Location:  Bangalore
Employment Type:  Contract
Experience:  10-17 yrs.
Valid Through:  05-03-2018

Job Description:

 

A highly competent professional with 10 to 15 years of experience in Database design, Data Modelling, Data Analysis, Data Architecture and implementations including data warehouse, operational data stores, and data marts. The candidate must have strong communication skills and be able work with both users and lead IT team members in a highly collaborative team environment. Candidate should be disciplined, detail-oriented, self-motivated, and delivery-focused. Skills Required: Technical skills: • Strong understanding of Data Warehouse architecture and methodologies. • In-depth knowledge of dimensional data modelling based on Kimball methodologies. • Translating business Requirements into conceptual and physical models. • Proficient experience in working on conceptual, physical and logical data models using Data Modelling tools like Erwin. • In-depth knowledge and hands-on experience with data integration, Data Migration, Data Profiling, Data conformance, Data Quality, Data Governance and Data Lineage. • Perform detailed data analysis. • Experience in developing data strategy, data governance, data architecture and standards. • In-depth knowledge and hands-on experience in more than one of the relational databases like Oracle, SQL Server, Redshift, TERADATA, DB2, etc. • Develop data modelling standards and best practises. • Perform source data quality assessments. • Identify the appropriate data sources with the assistance of the business analyst. • Assist the Business Data Analyst in mapping the data from source to target. • Assist the Business Data Analyst and Data Integration team with data related issues such as assessing data quality, data consolidation, evaluating existing data sources. • In-depth knowledge and hands-on experience in ETL tools like Informatica, Datastage, BODI/BODS, Pentaho Data Integrator PDI or any other tool. • Experience in any of the Business Intelligence tools like Business Objects, OBIEE, Qlik view or Tableau. • Experience in architecting projects from start to finish Non-Technical skills: • Strong Communication skills • Strong Team management skills • Must have experience with On Site and Off Shore Development model. Skills Desired but not mandatory: • Microsoft SQL Server 2016 with strong SQL writing skills. • Hands on experience in using any of the ETL tools. Pentaho (PDI) is a plus. • Working experience in any of the Business Intelligence tools. Business Objects is a Plus. • Amazon Web Services(AWS) • Big Data technologies (EMR, Hive) • TOGAF

 

Login to Apply