Job Details

Email to Friend Save Back

ETL/Informatica Developer

DURHAM-27702, NC, US
02/10/2020

-

Required Skills

SQL programming skills, UNIX Shell Scripting

Company

Infinity Consulting Solutions, Inc

Experience

Job Description

Infinity Consulting Solutions is hiring an ETL Software Engineer to work at our client in Durham, NC!

You will have a combination of technical, interpersonal skills and business knowledge and will work on multiple medium to large projects.

You will design, develop, test and implement data integration solutions, support and monitor existing ETL processes.

The primary expertise is in Informatica, Oracle PL/SQL, UNIX, Control-m (or any other scheduling tool), and Axway.

Proven technical skills (PL/SQL, Oracle, Informatica, Hadoop, PL/SQL, UNIX scripting, Data Analysis, relational/dimensional modeling) and will be able to take oral and written business requirements and develop efficient code to meet expectations.

Responsibilities:

Participate in the development, improvement and maintenance of database applications both as an individual contributor and as a team member

Leading in the identification, isolation, resolution and communication of problems within the production environment.

Crafting, building, and maintaining the BI Reporting Platform (both internal and external/client facing applications) by closely working with Analysts

Leading developers and applying skills in UNIX commands and shell scripting, Oracle, PL/SQL, SQL Tuning,
Informatica, Sqoop, SparkSQL and data modeling.

Design multifaceted processing through PLSQL for projects and able to build SQL database packages and procedures

Crafting high performing batch programs and adhering to standards and best-practices for development.

Performs independent functional and technical analysis for major projects supporting several corporate initiatives

Communicate and Work with IT partners and user community with various levels from Sr Management to detailed developer to business SME for project definition

Works on multiple platforms and multiple projects concurrently

Performs code and unit testing for complex scope modules, and projects

Must participate in rotating production support activities

25% Scrum master responsibility like arranging sprint planning, sprint review, etc.

Qualifications:

5 years of technical professional experience desired

At least eight years of experience with Oracle database development.

At least 3or more years of PL/SQL programming skills.

Proven experience in the following areas: UNIX Shell Scripting, Informatica ETL & Agile Scrum experience.
Agile/Scrum

Comprehensive experience with database systems and related software

Experience with Control M (or similar job scheduling AutoSys)

A minimum of 2 years of experience reading and interpreting physical data models

Proven knowledge of DBMS optimizer and performance tuning techniques; More than 5 years of experience translating requirement documents into DBMS language

Experience with regression testing and stored procedure development

Good communications skills with the ability to articulate clearly with peers and colleagues

Experience working with off-shore environments and Financial Services experience required

Must have a flexible attitude and comfortably accommodate change; excellent problem solver, able to assimilate information quickly.