14 days old
2017-11-062017-12-04

Informatica Developer

Charlotte, NC 28202
  • Job Code
    586213
  • Payrate
    $52 To $58

Informatica ETL Developer


Job Description:


The Informatica ETL Developer will be working with the Outage Communications team to design, develop and maintain solutions that require ETL resources. Initially this resource will be assigned to a project focused improving customer communications during large outages.


The candidate will need to understand business and technical requirements and translate this into data integration designs and deliverables. The solutions must align with Client ETL standards and guidelines.


The data integration solutions will be based on Informatica with MS SQL data warehouses/database. The position also requires supporting the SDLC process in terms of testing, and deployment.


This resource may be allocated to more than one initiative at a time based on skills demand and size of initiatives, and will be expected to adeptly manage tasks, timelines, priorities and communicate effectively to optimize workload.


ESSENTIAL DUTIES/RESPONSIBILITIES


- Design and Develop ETL programs primarily using Informatica PowerCenter, PL/SQL, Unix Shell Scripts


- Extract, transform & load into dimension model structures of EDW & data marts


- Performance improvement & tuning of Informatica mappings, SQL & PL/SQL scripts


- Strong SQL skillset with demonstrated experience on SQL Server, Oracle, DB2


- Technical reviews, Data validation & end to end testing of ETL Objects, Source data analysis and data profiling.


- Create necessary documentation as per SDLC standards


- Update the project documentation (Change Requests and JIRA's) on the confluence


- Upload the code to version control tool (GIT)


- Perform Unit Testing of ETL Programs and support QE on End-to-End testing


- Work with deployment team in the code migration across the SDLC environmentS


Programs and directs other programmers in required programming languages, database SQL, report writing, ETL, Assists with testing and migrating code through test regions.


Ensures adherence to appropriate design, coding and source control standards. Leads design and code walk-thru as a presenter or reviewer.


Processes Change Requests and Quality Assurance (QA) documentation for project implementations and support changes.


Required Qualifications: Bachelor degree in Computer Science or a related discipline.


In lieu of a degree, 8 years of related business experience. Work experience in addition to degree: 5-10 years as an IT Application Developer or equivalent.


Job-specific knowledge, skills or abilities:


Four years coding/programming, trouble-shooting, problem-solving, logical design, SQL coding, Business Requirements analysis, vendor management, root cause analysis.


Preferred Qualifications: Expert coding skills in 1 or more standard languages. Demonstrated success in complex problem solving and an understanding of quality delivery.


Demonstrated ability to work with others having differing priorities/views/goals than your own; to meet your goals. Understand and lead others in use of System Development Life Cycle (SDLC). Effective communication skills. Experience with schema/database design, Enterprise Standards and Process Adherence.

Categories

  • Information Technology

Randstad utilizes a technology-driven focus with a human touch to provide better staffing and business solutions to organizations around the world. Our team of experts match professionals with available career opportunities in a variety of fields.

Featured Jobs

Career News

Share this job:

Informatica Developer

Randstad Technologies
Charlotte, NC 28202

Share this job

Informatica Developer

Randstad Technologies
Charlotte, NC
US

Separate email addresses with commas

Enter valid email address for sender.

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast