015990TS Informatica Data Movement ETL Lead in Smithfield, RI (W2 ONLY

PMG Global

2019-09-05 00:36:19

Job location Smithfield, Rhode Island, United States

Job type: fulltime

Job industry: I.T. & Communications

Job description


Our ETL Technical Lead has a combination of technical skills, communication skills and business knowledge. The lead should be able to work on multiple medium to large projects. The successful candidate will have excellent technical skills (PL/SQL, Oracle, Informatica, Hadoop, UNIX scripting, Data Analysis, relational/dimensional modeling) and will be able to take oral and written business/systems requirements and develop efficient code to meet deliverables.


  • Take up the responsibility of the entire Project in terms of design, development, enhancements and support after production
  • Working with the Systems analyst and designing Complex data solutions independently
  • Leading the team towards developing the detailed design structure after understanding the requirements and the design
  • Leading in the identification, isolation, resolution and communication of problems within the production environment
  • Designing, building, and maintaining the BI Reporting Platform (both internal and external/client facing applications) by closely working with Analysts
  • Designing high performing batch programs and adhering to standards and best-practices for development
  • Performs independent functional and technical analysis for major projects supporting several corporate initiatives
  • Communicate and Work with IT partners and user community with various levels from Sr Management to detailed developer to business SME for project definition
  • Works on multiple platforms and multiple projects concurrently
  • Participate in production support activities on rotation basis


  • Eight to ten years of experience in database development. Primary focus being Informatica and Oracle (including but not limited to SQL, dynamic SQL, PL/SQL, DBMS optimizer, performance tuning, analytical functions etc.)
  • Expertise in UNIX Shell Scripting
  • Expertise in reading and interpreting physical data models
  • Excellent technical abilities, leadership, decision making, strong communication skills, problem solving and adaptability to new technology
  • Comprehensive experience with database systems and related software
  • Experience with Control M (or similar job scheduling AutoSys)
  • Ability to translate requirement documents into DBMS language
  • Must have a flexible attitude and be able to comfortably accommodate change
  • Effective time management skills in order to manage multiple priorities with flexibility on time zones and timelines

- provided by Dice

Inform a friend!