ETL Developer

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