Informatica ETL Developer
Job Title: Informatica ETL DeveloperLocation: Jersey City, NJ // Addison, TX (onsite)Duration: Full TimeJob DescriptionResponsibilities:· 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:· Bachelor’s 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