Informatica / Hadoop - Technical Lead

Informatica 9.x, Big Data Hadoop Eco-system, Hadoop HDFS / Pig / Spark / Oozie, NoSQL Databases - Hive /Impala/MongoDB/Cassandra, Oracle 10g and above
Full Time, Contract Independent, Contract W2, C2H Corp-To-Corp, C2H Independent, C2H W2, 12
Depends On Experience

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

Dice Id : 10441386
Position Id : 2021-2201
Originally Posted : 5 months ago
Have a Job? Post it

Similar Positions

Big Data Engineer (Hadoop, Spark)
  • Systems Technology Group Inc. (STG)
  • Dearborn, MI, USA
Big Data / Hadoop Developer
  • N2 Services Inc
  • Detroit, MI, USA
Senior Hadoop Developer
  • Dechen Consulting Group
  • Dearborn, MI, USA
Hadoop Bigdata Developer
  • Advent Global Solutions, Inc.
  • Dearborn, MI, USA
Lead Alteryx / Pyspark
  • Advent Global Solutions, Inc.
  • Dearborn, MI, USA
Hadoop ETL Developer
  • HTC Global Services, Inc.
  • Troy, MI, USA
Hadoop Developer
  • Systems Technology Group Inc. (STG)
  • Dearborn, MI, USA
Lead informatica with hadoop exp
  • Reliable Software Resources
  • Strongsville, OH, USA
Hadoop Developer
  • Computer Resource Solutions
  • Chicago, IL, USA
Hadoop Developer
  • Dovenmuehle Inc.
  • Lake Zurich, IL, USA