Job Description :
Job Title:Informatica Lead Developer
Location: Jersey City, NJ
Duration: Full-time

Job Description:

Exp with PL/SQL.
Exp with ETL and ELT 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 ..