Job Description :
*Informatica Lead Dev*

*Location: Jersey City , NJ*

*Nature: Fulltime (Visa independent) USC, GC, GC EAD*

*Exp with PL/SQL*

*Exp with ETL and ELT (EDW, Bigdata skills) both*

Total of 10 - 14 yrs experience with good domain exposure in Financial
Services Industry

Strong expertise on design and development of Informatica ETL, ELT
processes for EDW, BigData using appropriate models and techniques
Minimum of 5 years of hands-on technical experience with PL/SQL, data
architectures, data modeling, semantic data lake, batch, streaming, data
services

*Key Requirements:*

- Analysing business requirements to define functional and technical
specifications;
- Designing, developing, and enhancing technical solutions in
Informatica, PL/SQL and adept in performing data validation;
- Architecting database design and programming database objects
including stored procedures, Views, Functions, Tables, and Object oriented
types;
- Utilizing Unix AWK/SED commands to analyse data;
- Facilitating performance enhancements using database profiling, query
tuning, index design for optimized fetch, partitioning data, editing design
in data processing, and performance tuning of ETL process using advanced
methodologies including partitioning and parallel processing;
- Designing and implementing optimized scheduling solutions using
various scheduler tools including cron, and IBM TWS;
- Excellent communication skills across all levels; ability to
communicate with ease on the complex and technical concepts.

*Desired Experience/ Skills:*

- Exposure to Big Data Technologies such as Hadoop, MapReduce, Spark or
other Big Data Platforms
- Exposure to building and deploying data and analytics solutions on AWS
or Microsoft Azure cloud platforms
- Exposure to No-SQL technologies
- Exposure to Data Services, API, and OR mapping techniques.
             

Similar Jobs you may be interested in ..