Sign In
 [New User? Sign Up]
Mobile Version

Lead Informatica Developer


Norfolk, VA
Job Code:
  • Engineering
  • Transportation / Warehouse
  • Drivers/Transportation/Shipping
  • Engineering/Architecture
  • Factory/Warehouse
  • Save Ad
  • Email Friend
  • Print
  • Research Salary

Job Details

Company ADP USA

Job Title: Lead Informatica Developer

JobID: adp-5000176082406

Location: Norfolk, VA, 23509, USA

Description: 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. Responsibilities:
* 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 Qualifications:
* 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 #LITECH #cb#

Featured Employers

Featured Jobs

CareerConnection Video