ETL Informatica Lead in Smithfield, RI at Eliassen Group

Date Posted: 2/4/2020

Job Snapshot

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.

We will accept corp to corp or w2 contractors. For our w2 consultants, we offer a great benefits package that includes Medical, Dental, and Vision benefits, 401k with company matching, and life insurance.

Responsibilities:

  • 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

Requirements:

  • 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

Keywords: UNIX, Oracle, SQL, Informatica, SME,BI Reporting

Job ID: 334227

About Eliassen Group:

Eliassen Group provides strategic talent solutions to drive our clients’ innovation and business results. Leveraging over 30 years of success, our expertise in IT staffing, Agile consulting, creative services, managed services, and life sciences enables us to partner with our clients to execute their business strategy and scale effectively. Headquartered in Reading, MA and with offices from coast to coast, Eliassen Group offers local community presence, deep networks, as well as national reach. For more information, visit http://www.eliassen.com.

Eliassen Group is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.

Don’t miss out on our referral program! If we hire a candidate that you refer us to then you can be eligible for a $1,000 referral check!