ETL Informatica Developer

Job Position: ETL Informatica Developer

Job location: Jersey City, NJ OR

Addison, TX

Duration: Full time

Job Description:-

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:

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 be 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

Regards

Pragyan Dixit

Envision Technology Solutions