Informatica/Hadoop Technical Lead

company banner
Goahead Solutions
ETL, Informatica, Hadoop, Data Warehouse
Contract W2, Contract Independent, 12 Months
Depends on Experience
Work from home available

Job Description

GoAhead Solutions has a great opportunity in Detroit, MI for an Informatica/Hadoop Technical Lead.  This would be a Six to Twelve month contract to start out.

Job 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.



-Informatica 9.x and above (MUST)

-Informatica PowerCenter (MUST)

-Informatica Data Quality (STRONGLY PREFERRED)

-Big Data Hadoop Eco-system (preferably Cloudera distribution) (MUST)

-Hadoop HDFS / Pig / Spark / Oozie (MUST)

-NoSQL Databases - Hive /Impala/MongoDB/Cassandra

-Oracle 10g and above (MUST)

-Unix Shell Scripting - AIX or Linux (MUST)

-Amazon Web Services – AWS (MUST)

-Experience in any of Scheduling Tools - Tivoli, Autosys, Ctrl-M

-Bachelor's Degree in related field



-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)



-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



-Bachelors Degree in related field required such as Computer Science, Computer Information Systems or Computer Engineering. Master's Degree in related field preferred.

Company Information

GoAhead Solutions is comprised of a cohesive and diverse team of exceptionally talented people. Our clients inspire us to go the extra mile. Our team members encourage us to always be our best. There are many options to join the GoAhead Solutions team. We encourage new applicants to submit their ré sumé for consideration of existing and future job opportunities.
Dice Id : goaca001
Position Id : GO3006
Originally Posted : 2 months ago

Similar Positions at Goahead Solutions

Hadoop/Informatica Developer
  • Detroit, MI
  • 12 hours ago