ETL/Informatica Developer

About the role

A client of Innova Solutions is immediately hiring for an ETL/Informatica Developer.

Responsibilities

• 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.
• InformaPowerCenter 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
• 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

• Mapping/Mapplets/Workflows
• Informatica
• Power Center
• Oracle PL/SQL
• Autosys

Qualifications

• Experience on SDM Adoption / Horizon onboarding tools (Bit Bucket, Datical, Jenkins)
• Agile best practices
• Experience on Informatica PowerCenter 10.x
• Experience on Oracle PL/SQL
• Experience on Unix Concepts

Skills

• Mapping/Mapplets/Workflows
• Informatica
• Power Center
• Oracle PL/SQL
• Autosys

Benefits

• Medical & pharmacy coverage
• Dental/vision insurance
• 401(k)
• Health saving account (HSA) and Flexible spending account (FSA)
• Life Insurance
• Pet Insurance
• Short term and Long term Disability
• Accident & Critical illness coverage
• Pre-paid legal & ID theft protection
• Sick time
• Other types of paid leaves (as required by law)
• Employee Assistance Program (EAP)

Pay

Pay Range*: $68/hr. on W2

*Pay range offered to a successful candidate will be based on several factors, including the candidate's education, work experience, work location, specific job duties, certifications, etc.

Schedule

Duration: 12 + Months

Location

Locations: Jersey City, NJ