Senior Informatica Data Integration & Transformation - Onsite
The Dignify Solutions, LLC
Dice Job Match Score™
👤 Reviewing your profile...
Job Details
Skills
- INFORMATICA
- POWERCENTER
- INFORMATICA POWERCENTER
- POWERCENTER 10
- POWERCENTER 10.X
- IDMC
- INFORMATICA DATA MANAGEMENT CLOUD
- IICS
- INFORMATICA INTELLIGENT CLOUD SERVICES
- ETL
- EXTRACT TRANSFORM LOAD
- DATA INTEGRATION
- DATA WAREHOUSE
- DATA WAREHOUSING
- DATA MART
- OLTP
- OLAP
- BUSINESS INTELLIGENCE
- BI
- SQL
- COMPLEX SQL
- STORED PROCEDURES
- VIEWS
- ORACLE
- ORACLE PL/SQL
- ORACLE 11G
- ORACLE 10G
- ORACLE 9I
- SQL SERVER
- MS SQL SERVER
- T-SQL
Summary
Job Description:
- Must have at least 6+ Years of working experience in ETL Informatica tools.
- Responsible for designing, developing, and maintaining complex data integration solutions using Informatica tools using Informatica PowerCenter10.x and IDMC.
- PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools –Informatica Server, Repository Server manager.
- Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, SQL Server Databases.
- Hands on experience in IICS and IDQ.
- Extensive experience in developing Stored Procedures, Views, Complex SQL queries using SQL Server and Oracle PL/SQL.
- Gather the requirements from the business and create detailed technical design documents, and model data flows for complex ETL processes using Informatica PowerCenter
- Experience in resolving on-going maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions.
- Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documentation.
- Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, XML,Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
- Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP.
- Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
- Ability and experience in managing/ coordinating with Onshore-Offshore teams
- Dice Id: 91139083
- Position Id: 26-00289
- Posted 10 hours ago
Company Info
About The Dignify Solutions, LLC
The Dignify Solutions with Global Capabilities and Local Excellence – has combined experience of 30 +years in Client Services/ Engagement/ Relationship/ Partnership, Sales/ Account Management, Service Delivery, Recruiting, Staffing and Talent Acquisition for the whole gamut of skillsets in Information Technology (Digital Transformation, Artificial Intelligence, Machine Learning and other business domains).
The Dignify is dedicated to meeting the needs of two types of customers: our Clients and our Consultants. We ensure that our clients receive Top Talent while also allowing our consultants to accomplish their Professional Goals.
The Dignify honors & prioritizes the Philosophy of Client Centricity and Delivery Excellence. The Dignify has dedicated Sales and Delivery Teams with each client, to make sure our standards and yours are being met. From Banking and Financial Services, Manufacturing and Retail, Energy and Utilities, Communication and Media, Technology and Telecom Services and beyond, our goal is to maintain a High Quality, Customer-Focused Engagement Model.
We are driven by three core principles in changing Staff Augmentation for the better: Cost, Quality, and Responsiveness. Whatever your need – be it a single resource or a whole team, we will find you the right talent in a timely and cost-effective manner.
The Dignify offers the Best Skilled Potential Talent, Services and Solutions to help our clients, accomplish their goals. As Market Intelligence Leaders, we provide insight into industry factors that will give you the competitive advantage you need to stay a step ahead of others in your space.
Never miss an opportunity! Create an alert based on the job you applied for.Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs