Data Analytics Consultant

Job Title: Data Analytics Consultant

Location: Horsham PA (Onsite)

Duration: 6 12+ Months

Job Description:

Technical Skills

• Informatica expertise with an emphasis on working with a diverse set of sources and targets, implementing auditing, error trapping/tracking, reusability and restartablilty, and the ability to troubleshoot and performance tune Informatica mappings, sessions and workflows
• Informatica PowerExchange CDC experience on Oracle, DB2, and Mainframe preferred
• Exadata, Teradata, or Netezza Appliance database expertise
• PL/SQL or T-SQL experience
• Deep understanding of Data Warehousing principles with hands on experience with slowly changing dimensions and fact tables
• Healthcare, Data Warehouse, Informatica and EXADATA

Responsibilities:

• Informatica PowerCenter development with an emphasis on working with a diverse set of sources and targets, implementing auditing, error trapping/tracking, reusability and restartablilty, and the ability to troubleshoot and performance tune Informatica mappings, sessions and workflows
• Development of Informatica PowerExchange CDC Data Mappings and workflows to support real time ETL and Reporting.
• Development of PL/SQL to include execution of a number of queries in one block using single command, provide features to handle exceptions, extensive error checking, and create a PL/SQL unit such as procedures, functions, packages, triggers, and types, which are stored in the database for reuse by applications
• Design ETL within Data Warehouse and Operational Data Stores that are leveraged across the business to enable data driven decisions
• Lead team design, solutioning, development and support efforts
• Provide direction and mentor Team members
• Day to Day collaboration with Scrum Teams, providing support to our developers and testers
• Participation in a rotation for operations support, prod and non-prod
• Participation in software release and deployment