Informatica ETL Developer

Siri InfoSolutions Inc

Job Location:

Jersey, NJ - USA

Monthly Salary: Not Disclosed

Posted on: Yesterday

Vacancies: 1 Vacancy

Job Summary

Responsibilities:

Support technical delivery through coding development and testing;
Understanding of automated processes for building testing (integration SIT & UAT Support) documenting and deploying at scale;
Translate user requirements into the overall architecture framework and implementation of new systems;
Create test code to validate the application against client requirement;
Understand create and debug database related queries;
Ensure complete technical documentation exists for all projects and processes;
Maintain successful relationships with application developers;
Performance Optimization;
Develop informatica mappings debugging using queries on source and targets;
Successful resolution of production issues.

Requirements:

Bachelors Degree in Computer Science Computer Engineering or a closely related field;
Strong knowledge of SQL Relational Database Management Systems like Oracle DB2 and SQL Server;
Experience scripting macros in MS Excel;
2-3 years SQL is required;
2-4 years ETL (SAS) experience required;
Proven success in contributing to a team-oriented environment;
Scala development skills;
Experience working with Client IT and Business Team for requirements gathering;
Good understanding on the parameter file concepts and how they can leveraged for good design and solutions;
Proven ability to work creatively and analytically in a problem-solving environment;
Knowledge in Informatica server and application administration;
Experience with Informatica Advanced Techniques Dynamic Caching Memory Management Parallel Processing to increase Performance throughput;
Designing and implementing Informatica 10.1 PowerCenter mappings;
Strong SQL and related skills. Ability to develop and implement complex procedures and packages using Oracle PL/SQL;
Desire to work in an information systems environment.
Working in Agile Teams.
Knowledge of Jira & Bitbucket

Responsibilities: Support technical delivery through coding development and testing; Understanding of automated processes for building testing (integration SIT & UAT Support) documenting and deploying at scale; Translate user requirements into the overall architecture framework and implementation o...