Job Description :
Role: Informatica/Hadoop Technical Lead
Location: Detroit, MI
Interview type: Skype.

Informatica/Hadoop Technical Lead
The Informatica/Hadoop Technical Lead must have prior hands-on (MUST) experience delivering/leading successful data warehousing projects (Informatica) as well as broad background and experience with IT application development (Hadoop This individual is responsible for working with other teams to deliver the artifacts and the code. This person must have strong professional consulting skills and the ability to communicate well at all levels of the organization.
REQUIRED EXPERTISE IN TOOLS & TECHNOLOGIES:
Informatica 9.x and above (MUST)
Informatica Power Center (MUST)
Informatica Data Quality (STRONGLY PREFERRED)
Big Data Hadoop Eco-system (preferably Cloudera distribution) (MUST)
Hadoop HDFS / Pig / Spark / Oozie
NoSQL Databases - Hive /Impala/MongoDB/Cassandra
Oracle 10g and above (MUST)
Unix Shell Scripting - AIX or Linux (MUST)
Experience in any of Scheduling Tools - Tivoli, Autosys, Ctrl-M
Bachelor''s Degree in related field
OTHER SKILLS/EXPERIENCE REQUIRED:
More than 3 years of experience as a Senior ETL Developer
More than 5 years’ experience as ETL Developer using Informatica and Oracle 10g/11g to implement data warehousing projects
Working knowledge of Informatica Data Quality is preferred
More than 2 years of experience in leading/designing Informatica /Hadoop projects
Excellent understanding of data warehousing concepts.
Candidate should be able to clearly communicate fundamental concepts during interview and demonstrate previous experience in all aspects.
MUST HAVE strong SQL skills in Oracle 10g/11g
Experience in Oracle database programming using Partitioning, Materialized View and OLAP
Experience in tuning Oracle queries/processes and performance management tools
Strong data modeling skills (normalized and multidimensional)
Strong business and communication skills
Knowledge of Health Care Insurance Payer Data Warehousing Preferred
Preferred Certifications:
Cloudera (CCP / CCA)
RESPOSIBILITIES:
The Senior Developer should be able to perform the following with minimal supervision:
Understand Business Requirements and Conceptual Solution
Convert Business Requirements into Technical Requirements and Design
Create High Level Design and Detailed Technical Design
Create Informatica Mappings, Workflows and Sessions
Create Shell Scripts for automation
Understand the source systems and conduct the data profiling
Co-ordinate Data Modeling of Sources and Targets
Create Source to Target Mapping Specifications from the Business Requirements
Review Unit Testing and Unit Testing Results Documents
Provide Support for QA/UA Testing and Production code migrations
Provide warranty support by assisting/resolving production issues

The Senior Developer should have the following leadership skills:
Provide hands on technical leadership
Lead technical requirements, technical and data architectures for the data warehouse projects
Direct the discovery process
Provide knowledge guidance to Business Analysts and ETL Developers
Provide subject matter expertise and knowledge guidance to a team of analysts and ETL Developers
Lead the design and development of the ETL process, including data quality and testing
Follow the standards and processes defined
Contribute for process and performance improvements
Ensure compliance of meta data standards for the data warehouse