Our Client, a Banking company, is looking for a ETL Informatica Developer for their Jersey City, NJ location. Responsibilities: + Resource to design, develop, maintain and test software, collaborating with the development team and business partners to ensure successful delivery and implementation of application solutions in an agile environment. + Should be hands on and able to develop ETL packages using Informatica PowerCenter + Participates in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications. + Creates ETL Mappings, Mapplets, Workflows, and Worklets using Informatica PowerCenter 10.x and prepare corresponding documentation. + Designs and builds integrations supporting standard data warehousing objects (type-2 dimensions, aggregations, star schema, etc.). + Performs source system analysis as required. + Works with DBAs and Data Architects to plan and implement appropriate data partitioning strategy in Enterprise Data Warehouse. + Implements versioning of the ETL repository and supporting code as necessary. + Loads and transforms data from various external sources to Relational database using Informatica. + Work with complex transformations such as XML's, XML parser, Java and HTTP transformation and have designed SCD typ2 workflows. Requirements: + Informatica PowerCenter 10.x, Oracle 11g/12c SQL/PLSQL, AutoSys + Familiar with any version control tool + Oracle PL/SQL + Unix Concepts + Experience on SDM Adoption / Horizon onboarding tools (Bit Bucket, Datical, Jenkins) + Agile best practices + Informatica + Technical by default + Informatica PowerCenter + Oracle SQL / PLSQL Why Should You Apply? + Health Benefits + Referral Program + Excellent growth and advancement opportunities As an equal opportunity employer, ICONMA provides an employment environment that supports and encourages the abilities of all persons without regard to race, color, religion, gender, sexual orientation, gender identity or express, ethnicity, national origin, age, disability status, political affiliation, genetics, marital status, protected veteran status, or any other characteristic protected by federal, state, or local laws.