Informatica Developer Etl

PROFESSIONAL SUMMARY

Over * years of Experience with Informatica- Data Warehousing experience using Informatica Power center 10.x/9.x/8.6/8.1.1/8.0/7.1.2/7.1.1/7.0/6.1

Experience in dealing with various data sources like Oracle 10g/9i/8i, Oracle PL/SQL, AS400, SQL Server 2000 /2005, DB2, MS-Access, MS – Excel, and Flat files.

Experience in Dimensional Data Modeling experience in Data modeling, Dimensional Modeling, OLAP, FACT & Dimensions tables, Physical & Logical data modeling.

Developed the required data warehouse model using Star schema for the generalized model

Transformations: Experience in creating Mappings and Mapplets using variously Connected and Unconnected transformations like Source Qualifier, Aggregator, Expression, Lookup, Filter, Joiner, Union, Router, Rank, Sequence Generator, and Update Strategy transformations.

Created Reusable Transformations, Mapplets, Sessions, and Worklets and made use of the Shared Folder concept using shortcuts wherever possible to avoid redundancy.

Worked exclusively on implementing the types of slowly changing dimensions (SCDs) - Type I II and III in different mappings as per the requirements.

Data cleansing experience using UNIX Shell Scripting and SQL coding.

Designed and developed ETL workflows to work with various sources and targets like MS SQL Server, DB2, Oracle, My SQL, and Flat files.

Performance tuning: Expertise in session partitioning, session tuning by optimizing Source, target, mappings, and transformations.

Expertise in preparing the ETL Design Documents like High Level and low-level Design documents.

Used different debugging techniques like the Informatica debugger, creating temporary tables and session logs to resolve complex issues.

Involved in the Unit testing, System integration testing, and UAT using Quality Center.

Interaction with different teams from Clients, BI teams, to end-users for further enhancements.

Capable of rapidly learning new technologies and processes, and successfully applying them to projects and operations.

Outstanding communication and interpersonal skills, ability to learn quickly, good analytical skills, and high compliance to new technologies and tools.

TECHNICAL SKILLS

ETL Tools

Informatica Power Center 10.2.0,9.5.x, 9.x, 8.x, 7.x (Designer, Workflow Manager, Workflow Monitor, Repository Manager, Repository Server)

CRM Tools

Salesforce.com

Salesforce Tools

Eclipse, Data Loader

Salesforce Technologies

SOQL, ETL, Custom Objects, Sandbox Testing

Databases

DB2, Oracle11g/10g/9i/8i MS SQL Server 2012/2008/2005/ 2000, MS Access 2010/2003/2000, IBM DB2, Cassandra, Greenplum, AS400

Programming

SQL, PL/SQL, T-SQL, UNIX Shell Scripting

Scheduling Tools

AutoSys, Control-M, Automic

Reporting Tools

Power BI, Tableau

Operating System

Windows, Linux, HP-UX

Version Control

SVN, GIT

File Transfer Solution

Globalscape, MOVEit

Methodologies

Waterfall, Spiral, Agile

Database tools

Datastax Studio, PgAdmin III

Open API

Swagger

IT Service Management Tool

HP Service Manager, ServiceNow

Deployment Tool

Cross-Vista

Automation Tool

Red Hat Process Automation Manager

PROJECT SUMMARY

ASSURANT, CHICAGO, IL AUG 2020 -TILL DATE

Sr. ETL/Informatica Developer

Responsibilities

Responsible for business requirements collection and analysis to develop use cases required for the development of Data warehouse application.

Work with various clients to maintain data in our centralized system with various technologies like FTPs, Informatica, Salesforce, File transfers, ServiceNow, Automic etc

Hands-on experience using salesforce, and the inspector to check the in and out data flow.

Involved in the integration of salesforce with Informatica.

Monitor the incoming files sent by the end-users using the secure movement tool Globalscape and MOVEit file transfer.

Work on a rotation basis and act immediately on failures with simultaneous Testing of all the Interfaces with a huge amount of data and fixed bugs accordingly within the Mappings/ Workflows.

Use ServiceNow to quickly raise incidents and workaround solutions to resolve the unplanned failures in production.

Create reports from Salesforce to analyze the output data from Informatica 10.2

Maintenance of CRM functionality implementing SFDC and Creating SFDC reports (functional and technical documents).

Experience using Data loader and cleansing and de-duplicating Bulk loads.

Managing high caliber offshore development team and ensured all the development work meets business requirements and is delivered as per the plan.

Helped with coordinating data requirements from master data platform for downstream consumers with stewardship for various projects.

Involved in designing and developing of new Informatica process and re-used a lot of existing objects.

Designed and built an end-to-end orchestration process for key projects which helped analysts (end-users) in getting the required data near real-time.

Involved in gathering and analyzing the requirements and preparing business rules.

Involved in maintenance/enhancements and production support for various projects.

Verified and tested the code and migrated into IT and UAT environments and was involved in designing the specs with the Business Users.

Maintained a consistent Naming convention for Mappings, Transformations and Workflows name as per the business infrastructure documents.

Maintained documentation for every process including the Mapping and Transformation Rules, Source and Target definitions, Output Flat file locations, Shell Scripts, and Template files directories.

Used existing ETL standards to develop these mappings.

Worked on different tasks in Workflow like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer, and scheduling of the workflow.

Created sessions, configured workflows to extract data from various sources, transformed data, and loading into the data warehouse.

Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.

Extensively used SQL* loader to load data from flat files to the database tables in Oracle.

Modified existing mappings for enhancements of new business requirements.

Environment: Salesforce.com, Informatica Power Center 10.2/10.4.1, JIRA, Cisco WebEx, Fileshare, Microsoft Office, Data Studio, SQL, AS400 System INavigator, Notepad++, Confluence, QUIP, CSV files, Flat files, Unix Shell scripting, ServiceNow Globalscape, MOVEit

ANTHEM, RICHMOND, VA JAN 2020 -JULY 2020

ETL/Informatica Developer

Description: EPDSV2 is designed to deliver a Consolidated Provider Data System for the Enterprise, accommodate current and future Provider Demographic Data and Network Affiliation needs for all states, and serve as a Centralized Source of Truth for Provider Data. As part of the Provider Data Systems Team, implemented the process to tack the end-to-end data loads and delivering files to downstream users.

Responsibilities:

Involved in daily scrum, sprint planning, retrospective sessions, and product backlog grooming sessions for active user stories.

Tracking the tasks in a tracking tool called JIRA that is followed by email notifications will be received for each task that is allocated.

Involved in designing to track the end-to-end data loads in addition to the Enhancement of the existing staging layer.

Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.

Responsible for developing Informatica mappings using different types of transformations like Union transformation, Connected and Unconnected Lookup transformations, Router, Filter, Aggregator, Expression and Update strategy transformations for large volumes of Data.

Created Sessions and extracted data from various sources, transformed data according to the requirement, and loading into a data warehouse.

Worked on complex queries while layers advanced, Utilization of SQL queries to insert/update records into the record control table while the MDS loads start and complete.

Used command task for the recreation of parameter files and Created shell scripts to fine-tune the ETL flow of the Informatica workflows.

Responsible for Detail design of each interface with technical documents specifying at each stage of the data load. Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.

Worked with Post-session on-success variable assignment in Informatica Workflow manager to assign variable values from the mapping to the workflow variables.

Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections, and relational connections with frequent code migrations

Created re-usable, non-reusable; sessions and Email tasks for on success/on failure mails.

Follow up with teams to analyze and visualize the data loaded into the target systems using tableau.

Performed unit testing at various levels of the ETL and was actively involved in team code reviews.

Identified problems in existing production data and developed one-time scripts to correct them.

Fixed the invalid mappings and troubleshoot the technical problems of the database.

Creating technical design documents and approach documents for every user story and interacting with business teams about the development and changes.

Worked with QA teams in test plans and executed them at UNIT testing and supported system testing, volume testing, and User testing.

Interacting with various teams and migrating the worked components to higher environments and deploying the changes to production.

Environment: Informatica Power Center 10.2, JIRA, Cisco WebEx, SecureCRT, Putty, Ipswitch WS_FTP, WinSCP, Microsoft Office, Data Studio, SQL, Toad for DB2, Ultra Edit, Notepad++, Confluence, CSV files, Flat files, Unix Shell scripting, Control-M, AutoSys, ServiceNow

US BANK, SAN FRANCISCO, CA APRIL 2017-DEC 2019

ETL/Informatica Developer

US Bank revealed its new project with a new theme based on safety on customer information. Encryption and decryption of data staying safe namely, SHEILD PROTECTION. In this project, my involvement was very naïve. I’m involved in testing the attachments that were initially received which were of enormous data. Involved daily in loading data to salesforce and testing data encryption and coming up with various solutions to enduring data safety. Also involved in projects namely insight analysis, customer audit log, personetics, Banker chats, etc.

Responsibilities:

Involved incomplete understanding of the business requirement and involved in analyzing the sources to load into multiple data warehouses.

Designed Sources to Targets mappings from SQL Server, Excel/Flat files to Oracle, PostgreSQL using Informatica Power Centre.

Integrate with multiple teams to analyze the requirement for the source systems

Involved in daily deployments, closing tickets, incidents in HP service manager and service NOW

Develop the Perl and Shell scripts to automate the finance billing file.

Responsible for Detail design of each interface with technical documents specifying at each stage of the data load.

Responsible for developing complex Informatica mappings using different types of transformations like Union transformation, Connected and Unconnected Lookup transformations, Router, Filter, Aggregator, Expression and Update strategy transformations for large volumes of Data.

Assisted with implementation/upgrade of AutoSys and M-control troubleshoot errors, and documentation/procedures.

Developed SDE mappings to load a large amount of data from different sources to a staging area, SID mappings for loading the data from staging area to target system.

Implemented slowly changing dimension Type 1 and Type 2 for Change data capture using Version control.

Responsible for creating Workflow and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.

Follow up with BI teams to analyze and visualize the data loaded into the target systems using tableau and Power BI.

Wrote test plans and executed them at UNIT testing and supported system testing, volume testing, and User testing.

Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.

Environment: Informatica Power Center 9.5.x, MS SQL server 2012, Informatica IDQ, Data quality, Toad, PL/SQL (Stored Procedures, Triggers, Packages), AutoSys, CSV files, Flat files, Unix Shell scripting, MS Visio, Windows XP, Putty, Cassandra, Greenplum, HP Service Manager, ServiceNow.

AVERTRA, PITTSBURGH, PA July 2016- March 2017

ETL/Informatica Developer

NAGARJUNA CONSTRUCTION COMPANY (NCC) Aug 2013-July 2014

ETL Developer

Contact this candidate