- 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
OTHERSKILLS/EXPERIENCEREQUIRED:
- 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:
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
Best Regards,
Akhand Pratap
IT Technical Recruiter
Email: akhand@tekinspirations.com
Phone: 315-745-3723
W: www.tekinspirations.com
13573 Tabasco Cat Trail Frisco, TX 75035