Sign In
 [New User? Sign Up]
Mobile Version

Lead Informatica Developer


Norfolk, VA
Job Code:
Apply on the Company Site
  • Save Ad
  • Email Friend
  • Print
  • Research Salary

Job Details

JobId: 132093
Job Title: Lead Informatica Developer
Location: Norfolk, VA
Category: Technology
Employment: Full-Time
Open Date: 2017-01-30T06:09:07Z Close Date: 2022-01-29T00:00:00Z


You have one of the most important positions at ADP: Keeping our technology solutions performing for our 600,000+ clients and 57,000 associates around the globe. As part of the GETS team (Global Enterprise Technology Solutions), our mission is simple: Keep people productive by building solutions they want and keep them smiling with our awesome service. #winning

What's our secret sauce for success? Well, that's easy. It's our growing team of fantastic associates who make it all happen. We're collaborative, fast-paced, transparent, fun and expect the same from you. Your ideas matter and your impact can be felt from the moment you arrive.

So, are you ready to get in on the ground floor of something great? Awesome... ADP has a Lead Informatica Developer for our Norfolk location!

Job Summary

The Lead Application Developer will lead the development of building Data Integration solutions using Informatica Powercenter and Data Quality. The candidate will also provide design expertise and consultation to other developers in the team. The candidate will work with clients, analysts, architects and engineers to plan, design, develop, test and implement Data integration solutions consistent with business objective. The candidate is expected to be results-oriented, have knowledge of new and legacy technologies and relevant platforms.


  • Design, develop, implement and maintain programs to load, aggregate and extract the data to meet a wide range of business requirements using Informatica Powercenter
  • Responsible for integrating different ETL code modules
  • Lead the efforts in building Data Quality and matching solutions using Informatica Data Quality (IDQ)
  • Review requirements, perform data analysis and design ETL flow
  • Understanding of enterprise data warehouse, data federation, hub & spoke architectures
  • ETL and database performance tuning and optimization
  • Develop LINUX scripts to automate the load process
  • Create and execute Unit test plans
  • Participate effectively in relevant aspects of SDLC including Planning, development, testing, reviews and implementation
  • Translate client requirements into Informatica Powercenter and/or Data Quality (IDQ) mappings and workflows
  • Investigate and resolve data issues as needed
  • Prepare Technical design documentation
  • Maintain and support weekly/monthly load process


  • 7+ years of experience in ETL using Informatica Powercenter
  • 3-5 years of experience in Informatica Data Quality (Developer Client)
  • 5 years of experience in working with Oracle database
  • 3 years of experience in writing UNIX shell scripts
  • Expert in optimizing Informatica Powercenter mappings
  • 3 years of experience in building Data Models (Star schema and Snowflake schema) is preferred
  • Expert in tuning Oracle database by adding Indexes and creating Materialized views
  • Demonstrate in-depth understanding of Data Warehousing and ETL Concepts, ETL Loading strategy, Data Archiving, ETL Error Handling
  • Good oral and written communication skills are expected
  • A self-starting team player able to work independently



Software in the Cloud. Experts on the Ground:
ADP powers the working world with comprehensive solutions that drive business success. Consistently named one of the \"Most Admired Companies\" by FORTUNE® Magazine, and recognized by Forbes® as one of \"The World's Most Innovative Companies,\" ADP has over a half-million clients around the globe and 65 years of experience as one of the largest providers of human capital management solutions world-wide.

At ADP, we believe that diversity fuels innovation. ADP is committed to equal employment opportunities regardless of race, color, genetic information, creed, religion, sex, sexual orientation, gender identity, lawful alien status, national origin, age, marital status, non-job related physical or mental disability, or protected veteran status. We support an inclusive workplace where associates excel based on personal merit, qualifications, experience, ability, and job performance.

Apply on the Company Site
Powered By

Featured Jobs[ View All ]

Featured Employers [ View All ]