Job ID :
36075
Company :
Internal Postings
Location :
Newark, NJ
Type :
Contract
Duration :
6 Months
Salary :
DOE
Status :
Active
Openings :
1
Posted :
08 Mar 2022
Job Seekers, Please send resumes to resumes@hireitpeople.com

Must have skills:

  • Informatica
  • Strong SQL
  • Database

Detailed Job Description:

  • Need to have total 5-8 years’ experience
  • 3 years of experience in Informatica
  • Able to understand business requirement
  • Wealth Management domain knowledge is advantage.
  • Experience in Informatica upgrade work will add value.
  • Experience in Azure in Data Factory, Data bricks is advantage
  • Should be able to analyze requirement.
  • Able to manage client meeting, tech design meetings.
  • Should be able to understand and convey requirements to offshore team for development purpose.
  • Design, build and deploy effective Informatica Mappings and workflow using various transformation rules and various data scenarios.
  • Should have dealt with different types of source feeds (Mainframe files ,XML, CSV database feeds, Json).
  • Should have worked on scheduling application like Autosys or Control M.
  • Should have experience on working with Scrum methodology projects and able to deliver work on time with good quality.
  • Able to write Unix scripts.
  • Should know data warehouse concepts.
  • Translate requirements from the business and analyst into technical code
  • Identify and test for defects and bottlenecks in the ETL solution
  • Develop Database models and modify existing ones.

Essential Skills & Experience:

  • Advanced knowledge of Informatica Power Center, SQL, Unix , RDBMS and data modeling.
  • Experience with building Data warehouses desired.
  • Writes advanced SQL including some query tuning
  • Writes Unix scripts
  • Will work in Scrum environment.
  • Individual contributor to the project
  • Proficient in how to deploy to and debug a production Informatica environment

Minimum years of experience required: 8