SUMMARY

• Around 8 years of experience in Data Warehousing using Informatica Power Center 10.2/9.6/9.1/8.6/8.5 (Designer, Repository Manager, Workflow Manager, Workflow Monitor), Power Exchange 9.6/9.1 and knowledge on AWS services.
• Informatica Power Center Developer Certified Professional.
• Experience in analysis, designing, development, testing, debugging, documentation and maintenance of business applications with expertise in Data Warehousing Informatica ETL.
• Experience in designing and development of Star Schema, Snowflake Schema and creation of Fact Tables and Dimension Tables for the Warehouse and Data Marts.
• Good knowledge of OLAP and OLTP concepts and Data warehouse architecture.
• Experience in Integration of various data sources like Oracle, SQL Server, Flat Files, XML, COBOL, and DB2 into staging area.
• Extensive experience in using various Informatica Designer Tools such as Source Analyzer, Target Designer, Transformation Developer, Mapping Designer, Mapplet Designer.
• Hands on experience in tuning mappings, identifying, and resolving performance bottlenecks in various levels like Sources, Targets, Mappings, and Sessions.
• Experience on resolving on - going maintenance issues and provided on-call production support for the projects in production on weekly basis.
• Experience on Jira and ServiceNow for story tracking and ticketing.
• Hands on experience on Mainframe sources, Datasets and Data Maps using Power Exchange.
• Good knowledge on PL/SQL, SQL, Stored Procedures, Indexes, Table Partitions, triggers, cursors in Oracle and SQL Server and optimizing the SQL to improve performance.
• Experience in DTF tool (Data Testing Framework) and manual ETL testing for checking the accuracy of the data.
• Good hands on experience on Git to check-in the code and creating the branches and then merge to master in Bit Bucket.
• Hands on experience on Jenkins to deploy the code to next higher environments.
• Knowledge on AWS services like S3, EC2, EBS, CloudWatch, Lambda.
• Experience in writing UNIX shell scripts, calling Stored Procedures.
• Experience in using scheduling tools like Autosys, CA7.
• Actively involved in testing system upgrade of Informatica for version 9.1 to 9.6.1 and 9.6.1 to 10.2
• Excellent in communicating at all levels and involved in various client meetings and group discussions. A good team player and ability to work independently.
• Good knowledge and experience in Waterfall, Agile & Scrum methodologies.

TECHNICAL SKILLS

ETL/Informatica: Informatica 8.x/9.x/10.2 (Informatica Power center Designer, Workflow Manager, Workflow Monitor and Respository Manager), Slowly Changing Dimensions

Dataware Housing: EDW, ODS, DataMart, Ralph Kimball’s Model or Bottom-up Approach, Inmon’s Model or Top-down Approach

Databases: Oracle11g/10g/9i, SQL Server 2008/2012/2016 , IBM DB2 9/10, Sybase

Programming: SQL, Store Procedures, Functions, Triggers, Views

Software Methodologies: Waterfall Model, Agile/Scrum Methodologies

Tools: Toad, DB Visualizer, SQL Navigator, PLSQL Developer, Beyond Compare, Putty, Autosys, DTF, Git, Jenkins, ServiceNow, Jira

Operating Systems: Windows 10/7/XP/, Linux, Unix

PROFESSIONAL EXPERIENCE

Sr. Informatica Developer

Confidential, Urbana, MD

Responsibilities:

• Followed the Agile methodology development process with 2-week sprint cycle and used JIRA to track the tasks.
• Developed mappings in Informatica to load the data from the Source to Landing and from Landing to Reporting using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Filter, Stored Procedure, SQL Transformation and Sequence Generator transformations.
• Implemented Slowly Changing dimension methodology for ever to date history of loans and property Information.
• Used Informatica Designer to create reusable transformations to be used in Informatica mappings and mapplets.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target data mart tables using Informatica Workflow Manager.
• Participated in code reviews and implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Created Mapping Parameters and Variables and parameter files which were used to run the incremental loads and monthly loads.
• Developed view queries for the snapshot tables to maintain the active records.
• Worked with DBA’s to create PL/SQL, Stored procedures, and indexes in order to obtain optimal performance.
• Extensively used DTF (Data Testing Framework) for checking the accuracy of the data and validated data in the tables.
• Worked closely with Testers to test the data in each environment DEV/TEST/UAT/PROD.
• Followed the labeling concept to deploy the ETL code to next higher environments.
• Developed the Autosys Jill scripts (Box, Command and File Watcher) to schedule the Informatica jobs and added the dependencies per project requirement.
• Used GIT to check-in the code and created the branch and then merged them to master.
• Used JENKINS for the code deployment to higher environments.
• Provided the support for the projects in UAT and Production.

Environment: Informatica Power Center 10.2/9.6.1, Oracle 11g, SQL Server 2012/2016, UNIX/LINUX, Toad Data Point 4.2, Putty, Autosys, WinSCP, Windows 10, DTF (Data Testing Framework), Git, Jenkins.

Sr. Informatica Developer/PROD Support

Confidential, Jacksonville,FL

Responsibilities:

• Involved in various meetings with Business Partner and Technical People to gather the Business requirements and created design specifications and ETL design documents.
• Analyzed the source data coming from Mainframe, Flat Files, SQL Server 2012, and Coordinated with Technical people to gather the source information.
• Coordinated with the architect to create Tables and generate the Physical and Logical model with Erwin.
• Developed mappings in Informatica to load the data from the Source to Stage and Stage to ODS using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Filter, Stored Procedure and Sequence Generator transformations.
• Identified Facts and Dimensions and Created Aggregate Tables based on Reporting requirements.
• Implemented Slowly Changing dimension methodology for accessing the full history of accounts and transaction information.
• Used Informatica Designer to create reusable transformations to be used in Informatica mappings and mapplets.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target warehouse tables using Informatica Workflow Manager.
• Created the autosys jobs and coordinated with scheduling team to run the jobs on Daily and Weekly and monthly basis as per Business requirements.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Created Mapping Parameters and Variables and parameter files which were used to run the incremental loads.
• Used ServiceNow to create INC tickets and used Service Desk to track my work.
• Worked with Business Partners on Service Level Agreements (SLA).
• Extensively worked on UNIX Shell scripts and invoked oracle PL/SQL procedures and Informatica workflows via shell scripts. Created shell scripts to drop and re-create indexes to load data efficiently and decrease load time.
• Worked with DBA’s to create procedures and indexes and worked on database partitioning in order to obtain optimal performance.
• Actively involved in testing system upgrade of Informatica for version 9.1 to 9.6.1.
• Extensively worked with DBA on creating views and Materialized views to facilitate the Business Objects Universe design and creation of Adhoc and Canned reports.
• Coordinated with BO resource to create Universes using Business Objects Designer Module and different types of canned reports, such as Master/Detail, Cross Tab and Chart.
• Provided on-call support for the projects in production on weekly rotation basis and make sure we met all the SLA’s.

Environment: Informatica Power Center 9.6.1/9.1, Oracle 11g/10g, UNIX/LINUX, Mainframe, Toad 12, Putty, Autosys, Visio 2013, Windows 10/7