Sr. Informatica ETL Developer – Charlotte, NC 28217

Informatica Developer

Charlotte, NC

12-month W2 Contract

The Sr. ETL Developer will be working with the Enterprise Information Systems team to maintain and develop data integration solutions to support our Analytics 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 EDW, Data mart and ETL standards and guidelines. The data integration solutions will be based on Informatica with Oracle data warehouses/databases & Tableau for reporting platform. The position also requires supporting the SDLC process in terms of testing, deployment, and post production support.

ESSENTIAL DUTIES/RESPONSIBILITIES

  • Understand business requirements and convert them into detail technical specifications
  • 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
  • Technical reviews, Data validation & end to end testing of ETL Objects, Source data analysis and data profiling.
  • Develop new data integrations and support existing integrations for TriNet EIS team
  • Create necessary documentation as per SDLC standards
  • Update the project documentation (Change Requests and JIRAs) 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

JOB REQUIREMENTS AND QUALIFICATIONS

Education: Bachelor’s 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 6-7 years of experience in implementation of BI projects in a large scale enterprise data warehouse environment
  • Must have working experience in SFDC and PeopleSoft in areas of Sales, Marketing, Finance, or Support domains
  • 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
  • Hands on experience with database Performance tuning like Oracle, MSSQL Server, MySQL, and strong database languages like SQL, PL/SQL, TSQL, Unix Shell and Perl Scripting
  • Good Experience in tuning of Informatica mappings and Database scripts and procedures.
  • Highly experienced on On-site and Off-shore coordination with Managed Service Providers & IT teams
  • Excellent written and spoken communication skills

Other Knowledge, Skills and Abilities:

  • Excellent verbal and written communication skills
  • Excellent interpersonal skills
  • Knowledge of JIRA, Confluence Tools and other collaboration tools a plus
  • Good Team Player

Job Type: Contract

Salary: $60.00 to $67.00 /hour

Experience:

  • Informatica: 5 years (Required)

Work authorization:

About

Leave a Reply

Your email address will not be published. Required fields are marked *

DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.
close-link