Demonstrates expertise in a variety of the field’s concepts, practices, and procedures related to ETL/Data design and development. Implementing solutions using Informatica PowerCenter 9x/10x (Designer/Monitor). Develop and recommend strategies and specifications for (technical) data solutions based on the analysis of the business goals, objectives, needs, and existing data systems infrastructure.
Data Modeling and experience in developing new logical, conceptual, and physical models for data and system flows. Develop technical strategies and architectures for high-performance, scalable and complex enterprise-grade system. Work with ETL developers, business analyst, DBAs, system administrators, to architect data model, design and implement database as well as write ETL related programs.
Work closely with the team responsible for the maintaining the data model, including data dictionary/metadata registry. Document programming problems and resolutions for future reference. Work with Metadata Manager and business glossary to match technical data to business terms.
Candidate Skill Set
At least 5-7 years’ experience in a large Data Warehouse environment.
5-7 years’ experience in Informatica PowerCenter (9x/10x), focused on utilizing push down optimization, mapplets and worklets. Experience working complex transformations including update strategies, routers, normalizers etc.
3-4 years’ experience in Metadata Manager/Business Glossary
3-4 years’ experience in Linux/Unix
3-4 years’ experience in databases - Netezza or Teradata preferred
2-3 years’ experience with scheduling tools such as Autosys, TIDAL etc.
Strong understanding of Data Warehouse/MDM concepts (ETL, Star Schema, slowly changing dimensions). Strong knowledge of relational databases, Data Warehouse and business Intelligence solutions
Excellent teamwork and collaboration skills. Proficient in shell scripting and performance tuning within a Unix/Linux Environment