Technical Lead (Informatica/Hadoop)

Informatica 9.x, Data Quality, Hadoop, Oracle 10g, Unix Shell Scripting
Contract Corp-To-Corp, Contract W2, Long Term
Depends On Experience
Telecommuting not available Travel not required

Job Description

Role: Technical Lead

Location: Detroit, MI

Duration: Long Term

Interview Process: Skype

Open for US Citizens, G.C and H1b.


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


  • 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

Please submit your profile to:

Posted By

1520 State Hwy 130 N, Suite 201 North Brunswick, NJ, 08902

Dice Id : 10117295
Position Id : 440637
Have a Job? Post it

Similar Positions

Sr. ETL Developer Informatica Big Data Edition
  • NTT DATA, Inc.
  • Auburn Hills, MI
Big Data/ETL Lead Developer
  • Resource Point LLc
  • Detroit, MI
Informatica With Cloud
  • MeganSoft
  • Dearborn, MI
Senior Designer - ETL + Informatica
  • Fahrenheit IT
  • Dearborn, MI
Sr ETL/Informatica Developer
  • ePromptus Inc.
  • Southfield, MI
Informatica Cloud and Data Integration Developer
  • Systems Technology Group Inc. (STG)
  • Dearborn, MI
WebSphere Administrator
  • Xoriant Corporation
  • Dearborn, MI
Informatica BDM/ Informatica PC Developer
  • Wipro Ltd.
  • Auburn Hills, MI
Operational ETL Tech Admin/Developer
  • U.S. Tech Solutions Inc.
  • Auburn Hills, MI
  • Magna Systems International, Inc.
  • Southfield, MI
Integration Developer
  • Software Guidance & Assistance
  • Southfield, MI
Big Data Solution Lead and Architect
  • Reliable Software Resources
  • Detroit, MI