Informatica Technical Lead

HTC – A brief profile

Established in 1990, HTC Inc., a CMM Level 5 company with headquarters in Troy, Michigan, is a leading global Information Technology solution and BPO provider. HTC assists clients across multiple industry verticals, offering turnkey project lifecycle in, e-business, data warehousing, embedded systems, ECM, SCM, CRM, and ERP solutions. HTC Inc. offers ConnectIT, our Global Delivery Methodology that enables seamlessly delivery of outsourced IT services. HTC has global delivery centers across the globe.

About the Job

HTC is seeking to hire a Informatica Technical Lead Expertise.

Location: Madison, WIS

Duration: Long Term

Project Description:

• Expert Informatica Tech Lead
• We're looking for someone who can do Informatica PowerCenter coding and ETL, along with a strong knowledge of InformaticaÂ’s Data Transformation Studio toolset (DT Studio).
• They must understand XML and corresponding XSDÂ’s. 
• They should have broader data mart and data warehouse design skills.
• They must understand dimensional modeling.
• This candidate will need to analyze data, help design the data model for the data mart, document the data definitions and Informatica mappings, as well as code the mappings.

Skills Required:

• Extremely knowledgeable Informatica PowerCenter (Strong Informatica Mapping)
• Strong Knowledge of  Informatica Data Transformation (DT) Studio development -- MUST have DT Studio
• Extremely proficient in SQL development
• Extremely proficient in using XML
• Extremely proficient in designing data warehouse and data marts
• Extremely proficient in data analysis and problem solving
• Ability to document designs and clearly communicate alternatives
• Knowledge of data warehousing concepts and methodologies
• Understanding of the differences and similarities between Inmon and Kimball
• Understanding of Data Warehouse CDC (ChangeDataCapture) processing and challenges
• Demonstrated modeling skills in 3rd Normal form and dimensional techniques

Strongly Desired Skills:

• Oracle & DB2 database
• XML
• Data Modeling
• Business Objects

Benefits:

HTC’s competitive package includes besides compensation health, dental, vision, Disability cover, both Short and Long term, Life Insurance, Flexible Spending, 401k and paid vacation

Candidates should e-mail resume to VASU.GANNAMANENI@HTCINC.COM.

EEO/M/F/V/H