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