10 days old
2017-11-092017-12-07

Informatica ETL Developer

Raleigh, NC 27601
  • Job Code
    587100
  • Payrate
    $50 To $60

Randstad Technologies is looking for an Informatica ETL Developer to join our client for a year long contract in downtown Raleigh. The developer will be working with the Analytics & Data Services team to design, develop and maintain data provisioning solutions that require ETL resources. Initially this resource will be assigned to a project focused on data requirements associated with the Troux Enterprise Architecture platform. The candidate will need to understand business and technical requirements and translate this into data integration designs and deliverables. The solutions must align with our clients 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. The candidate for this position may become involved in other technical platforms, tools and skills of the Analytics & Data Services team over time, this role may not be limited to Informatica ETL development only. Thus the ideal candidate will welcome the opportunities to broaden their experience in data provisioning and analytics related tools and competencies.


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


- Triage the Production issues and work on the code fixes


- May participate in a 24x7 rotational on-call responsibility


JOB REQUIREMENTS AND QUALIFICATIONS


Education: Bachelors in Computer Science or Engineering desired, or equivalent education and/or related work experience. Training Requirements (licenses, programs, or certificates): Informatica Powercenter Certification is preferred


Experience:


- Minimum 2 years' experience with informatica Developer


- Minimum 5 years' experience with Informatica Power Center


- Minimum 6-7 years of experience in implementation of BI projects in a large scale enterprise data warehouse environment


- Knowledge of end-to-end SDLC process in EDW & BI projects


- Dimensional Modeling and Data warehouse, ODS concepts, such as star schemas, snowflakes and normalized data models


- Minimum 5 years of experience in ETL Architecture and ETL products especially on Informatica 9 and above


- Converting functional specifications into ETL technical specifications and source to target mappings


- Proven hands-on experience in using Informatica components such as Designer, Workflow Manager, Workflow Monitor, Repository Manager, etc Other Knowledge,


Skills and Abilities:


- Excellent verbal and written communication skills


- Excellent interpersonal skills - Experience working as part of an Agile team


- Strong knowledge of Agile SCRUM and Kanban methodologies


- Experience with JIRA, other Confluence and collaboration tools a plus


- Professional approach to working with geographically distributed teams, peers and clients included; individual needs to be able to work independently, understanding how to prioritize and accomplish tasks across several initiatives, targeting success on all. 4 yr Degree or a combination of education plus equivalent work experience

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 ETL Developer

Randstad Technologies
Raleigh, NC 27601

Share this job

Informatica ETL Developer

Randstad Technologies
Raleigh, 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