• Us Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 25th Nov 2020

Must have hands on Hadoop Lead Experience
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
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