Job Seekers, Please send resumes to resumes@hireitpeople.com

Must Have:

5+ years Informatica Power Center  (they are on 10.2, but version doesn’t matter terribly) . Strong SQL and PLSQL skills.   Recent experience in an Oracle Database environment. Analytical and problem solving skills. Great communication skills, team player, wants to work in collaborative environment.

Detailed Job Description:

Develop and maintain ETL (Data Extraction, Transformation and Loading) mappings using Informatica Designer 8+ to extract the data from multiple source systems that comprise databases like Oracle, SQL Server, flat files to the Staging area and then to the Data Marts. Create mappings using different look-ups like connected, unconnected and Dynamic look-up with different caches such as persistent cache. Perform impact analysis of the changes done to the existing mappings and SQL and provide understandable feedback. Create mappings using reusable components like worklets, mapplets using other reusable transformations. Document code. Demonstrate a strong understanding and coding ability in SQL. Work together on regular releases to push workgroups/Informatica code and SQL to production; need to be able to understand typical deployment concepts and processes (i.e. change control). Possess strong analytical and communication skills with a knack for learning and understanding business scenarios. Have the ability to work both as a team player and individually. Participate in providing the project estimates for development efforts. Demonstrate a solid work ethic with accountability and awareness to deliver on time and accurate; yet still be able to enjoy time spent on the job.

Experience required: 5 Years