Informatica/Hadoop Technical Lead

Title: Informatica/Hadoop Technical Lead
Location: Detroit MI
Duration: 12 months  
 
DESCRIPTION: 
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 Data Quality (STRONGLY PREFERRED)
Big Data Hadoop Eco-system (preferably Cloudera distribution)
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
 
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 the 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
 
Education/ Experience
Bachelor's degree in computer science, information systems, computer engineering, systems analysis, or related field required. Master's degree in computer science, information systems, computer engineering, systems analysis, or related field preferred. 
7 years of experience in multiple technology areas required. 
Demonstrates strong knowledge in one or more major technology areas. 
Knowledge of the business required.

Want to apply later?

Type your email address below to receive a reminder

ErrorRequired field

Apply to Job

ErrorRequired field
ErrorRequired field
ErrorRequired field
Error
Error
insert_drive_file
insert_drive_file