Manage, analyze, plan, develop, and implement data quality and data governance solutions to meet strategic, usability, performance, reliability, scalability, control, and security requirements. Requires demonstrable knowledge in areas of data quality and data governance along with solid experience with Informatica platform solutions.
Work you'll do
This is a unique opportunity to be a part of growing data operations and enterprise controls team that works on new and existing high-end data management platforms within Client. You will be responsible for development, implementation, and support of Informatica solutions to support organizational maturing of data management and data governance capabilities in a complex hybrid, multi-environment. Responsibilities include:
Understanding the business rules and sourcing data from multiple source systems
Extracted the raw data from Sharepoint, SQL Server, My SQL, Flat files to staging tables, and loaded data to topics in Integration Hub (CIH) using Informatica
Converted SSIS jobs to IICS jobs with help of BRD document and Flow chart from visio
Created Swagger files for connection to pull data from Service Now from CDI and for CUH to run PUB & SUB
Developed the audit tables for all the mappings
Integrated different sources from and to sharepoint, ServiceNow, SQL Server, Oracle, Flat Files IICS CIH Topics (PUB & SUB)
Automated/Scheduled the jobs to run daily with email notifications for any failures and Timeout errors
Documented the Sources, Targets and Mappings
Created and Developed mappings to load the data from staging tables, Files to EDQ DataMart tables, CIH Topics and topics to files based on Source to Staging mapping design document
Write PowerShell scripts to help smooth flow of files and ETL process
Performed testing activity by using SQL Queries to validate the data after loading
Maintain expertise in Informatica products and capabilities.
Develop data quality / data governance solutions as part of an onshore/offshore team working in an agile environment.
Execute work assignments and keep team updated on status/issues/challenges.
Work closely cross functional teams; align and influence stakeholders and resources to deliver data solutions to market.
Technical ability to understand project requirements.
Communication skills to work with application and vendor teams as required.
Perform troubleshooting and problem resolution when needed.
Work with other team members to provide 24/7 support for Production issues/outages.
Create and maintain technical documentation.
Design, develop, and support our Data applications and infrastructure utilizing various technologies to process large volumes of data.
Create solutions and environments to enable Analytics and Business Intelligence capabilities.
Implement data quality checks & Standardization in the code.
Deploy mappings that will run in a scheduled batch or real-time environment.
Document all mappings mapplets and rules in detail and hand over documentation to the customer.
Collaborate with various business and technical teams to gather requirements around data quality rules and propose the optimization of these rules as applicable.
Qualifications Required
Bachelor's degree in Computer Science or Business Information Systems or MCA or equivalent degree
6 to 8 years if experience with expertise in Design, Development and Implementation of Data Warehouse applications and Database business systems
Strong experience in all phases of development including Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using IICS Informatica (CAI, CIH, CDI) and Power Center (Repository Manager, Designer, Server Manager, Workflow Manager and Workflow Monitor)
Developed PowerShell scripts which help in smooth flow of files with process in Application Integration (CAI) and Data Integration (CDI)
Created N number of mappings mapping tasks and TaskFlows based on required in CDI
2 years of experience in IICS Informatica ETL Development using CIH, CDI, CAI
4 years of Experience in Power Center ETL Development using Repository Manager, Designer, Server Manager, Workflow Manager and Workflow Monitor
Experience converting SSIS jobs to IICS jobs
Hands on experience to pull data from Service Now and pull & load data to Sharepoint
Good experience in using Informatica Power Center 10.1/9.1 and Informatica for extraction, transformation and loading mechanism
Hands on experience with ETL testing and writing test cases to assure correctness in ETL flow by querying and collecting different level of information like Count of records in source and target databases
Good in writing UNIX shell scripting, Developed wrapper scripts for ETL and Load jobs
5 years of UNIX shell scripting experience for developing wrapper scripts for ETL jobs and for creating environment files, to create the jobs and job streams (schedules) for daily runs
Depth of SQL skills with Oracle, SQL Server
Extensively used Informatica Workflow Manager and Workflow monitor for creating and monitoring workflows, Worklets and sessions
Experience in maintenance and enhancement of existing data extraction, cleansing, transformation and loading processes to improve efficiency
Worked with SQL Server Stored Procedures and experienced in loading data into Data Warehourse/Data Marts using Informatica, SQL*loader, Export/Import utilities
Strong analytical, problem solving and multi-tasking skills, as well as communication and interpersonal skills.
Strong verbal and written communication skills, with an ability to express complex business concepts in non-technical terms.
Experience in Technical delivery using Agile Methodologies.
Experience working with cross-functional teams in delivery of new products or services.
Strong collaboration skills and self-motivated, taking ownership of deliverables and responsibilities.
Strong systems and application delivery ability.