ETL Informatica Developer
- Pyramid Consulting, Inc
180 Days Ago
65-67 per W2 Hourly
NA
Jersey City-NJ
8-10 Years
Required Skills: Oracle PL/SQL
Job Description
Title: ETL Informatica Developer
Location: Jersey City, NJ (Hybrid Onsite)
Duration: 1+ years
PR Range: $65 - $67 /hr. on w2 Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).
Job Description:
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
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.
· 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.
· 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
