Hadoop / Informatica Tech Lead
  • Detroit, Michigan, US
  • +914043515100
172 Days ago
Job Description

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


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

Required Skills
  • Not Available

  • NA

  • NA

Working Hours / Week