SUMMARY

• Have 8+ years of Technical and Functional experience in Data warehouse implementations using Informatica PowerCenter 9.x/8.x/10.x, Oracle 11g/10g, MS SQL Server.
• Comprehensive hands - on expertise in ETL Development.
• Experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center.
• Strong knowledge in Data warehousing concepts, dimensional modeling Star Schema and Snowflakes Schema, Fact and Dimensional tables, OLTP and OLAP Applications.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server and Oracle PL/SQL.
• Experience in resolving on-going maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions. experience on building scalable web service architectures with various relational ( MySQL, SQL Server, Red Shift)
• In-depth Knowledge of snowflake Database, Schema and table structure.
• Extensively worked on Transformations such as Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, and Sequence Generator.
• Define virtual warehouse sizing for snowflake for different types of work loads
• Proficient experience in translating business processes / requirements into technical requirements.
• Knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
• Proficient in using Informatica workflow manager, Workflow monitor to create, schedule and control workflows, tasks, and sessions.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
• Experience in writing various ETL procedures to load data from different sources like Oracle, DB2, XML Files, Flat Files, MS SQL Server and MS Access into Data marts, Data warehouse using Informatica Power Center.
• Implemented different slowly changing dimensions (SCD) using Informatica (all SCD Types).
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Experience in examining data from an existing source, summarizing information about that data, and using ETL expedite to get the accuracy, completeness of the data. sExperience in using transformations in Informatica PowerCenter, and knowledge on snowflake.
• Extensive experience on working with scheduling tools like Autosys and Control -M.
• Hands on experience in identifying and resolving bottlenecks in various levels like sources, targets, mappings, and sessions.
• Worked extensively on error handling, performance analysis and performance tuning of Informatica ETL components and SQL scripts.
• Experience in project deployment using ElasticSearchand using web Services like Amazon Web Services (AWS).
• Multitudinous experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, Unit testing, systems integration and user acceptance testing.
• Strong decision-making skills, organizational skills, and customer service oriented. Excellent analytical and problem-solving skills.

TECHNICAL SKILLS

ETL Tools: Informatica Powercenter 9.x/8.x/10.x (Powercenter Repository, Informatica Designer, Workflow manager, Workflow monitor, Source Analyzer, Mapping Designer, Mapplet, Transformations, Worklets).

Data Modeling: Relational Modelling, Dimensional Modelling (Star Schema, Snow-Flake, Fact, Dimensions), Data Quality, Entities, Attributes, ER Diagrams and AutoSys.

Database Platforms: SQL Server 2008/2012/2014 , MySQL, Oracle 10g/11g.

Programming/Languages: SQL, PL/SQL, Data structures, UNIX.

SDLC Methodologies: Agile/Scrum, Waterfall.

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

Sr.SQL-ETL Developer

Responsibilities:

• Created PL/SQL Packages, Stored Procedures for Data Transformation on the data warehouse.
• Involved in system study and transferred knowledge to offshore team.
• Involved in production support and ensured ETL processes works as expected.
• Created Jil jobs for AutoSys batch monitor that controls the data flow.
• Develop alert emails using shell scripts and/or informatica to the users.
• Imported data from file to Database using SSIS and created a new table in the DB.
• Defect fixing and controlling in case any jobs in batch monitor failed during batch run.
• Prepared Documentation for get SPs.
• Developed SCD type 1 and type 2 mappings in informatica to load and history data as per the requirement.
• Scheduled jobs as for the data flow in AutoSys.

Environment: SQL SERVER, Autosys, Informatica PowerCenter10.2

Confidential - Cedar Rapids, IOWA

Sr. SQL-ETL Developer

Responsibilities:

• ETL developer for IFRS9 regulatory implementation in Confidential asset management application.
• Coordinated with business analysts and business leads to gather requirements from business and developed them by following Agile - Scrum development process.
• Worked on IFRS9 - reporting project to extract the financial data from various data sources.
• Developed ETL mapping for extracting data from different sources like flat files and different databases.
• Created reusable transformations and Mapplets and used them in various mappings.
• Developed SCD type 2 mappings in Informatica to load the history data as per requirement.
• Created stored procedures and functions for commonly used PL/SQL blocks.
• Used different Cache properties, such as dynamic cache session property to perform the Update and Insert into the relational table simultaneously using Lookup transformation.
• Creating mappings to load data from Flat Files to Tables.
• Created Workflows, re-usable Worklets and Sessions using the Workflow Monitor.
• Creating views on DataMart tables to provide data to the business.
• Creating Unit Test Cases for the objects developed and creating test case documents.
• Performance improvement long running Informatica jobs and long running SQL scripts.
• Published builds to lower environments and provides unit test case results via sprint task board.

Environment: Informatica PowerCenter10.2, SQL server, Microsoft SQL Server Management Studio, Control-M.

Confidential - Charlotte, NC

ETL Informatica Developer

Responsibilities:

• Involved in System Study and transferred knowledge to offshore team.
• Involved in production support and ensured ETL processes works as expected
• ETL developer for CSAR reporting application.
• Participated in requirements discussion with business and all stake holders in team.
• Develop workflows in Informatica power center to pull data from Upstream servers and apply transformations according to business requirement
• Developed ETL mapping for extracting data from different sources, and integrated the Survey and Gust data.
• Deliver high quality code using stored procedures, functions and also packages in Oracle
• Design Autosys jobs in Unix that control the data flow
• Develop alert emails using shell scripts and/or Informatica to the users
• Bug fixing and controlling in case anything breaks down during batch run
• Generating recon report for every source against production data
• Electronic/Voice trades differentiator is a value add.
• Developed SCD type 1 and type 2 mappings in Informatica to load the history data as per requirement.
• Trained and worked in Neeteza, Snowflake data warehouses.
• Developed performance tuning, error handling techniques and Unit testing.

Environment: Informatica Power Center 10.0, SQL, Snowflake, Oracle 11g, Flat files, Agile, UNIX

Confidential - Raleigh, NC

ETL Informatica Developer

Responsibilities:

• Identification of various Data Sources and Development Environment.
• Prepared user requirement documentation for mapping and additional functionality. Created PL/SQL packages, Stored Procedures and Triggers for data transformation on the data warehouse.
• Design and Development of data validation, load processes, test cases, error control routines, audit and log controls using PL/SQL, MS SQL.
• Prepare user requirement documentation for mapping and additional functionality.
• Extensively used ETL to load data using PowerCenter from source systems like Flat Files and Excel Files into staging tables and load the data into the target database Oracle.
• Created PL/SQL packages, Stored Procedures for data transformation on the data warehouse.
• Developed joiner transformation for extracting data from multiple sources. Developed SCD type 1 and type 2 to load the history data as per requirement
• Worked on Tidal scheduling tool to run the job
• Scheduled the jobs in Tidal as per data flow
• Worked on eliminating single points of failure across the platform for high availability
• Tested the mappings and fixed the bugs as per QA bugs, and worked on Unit testing
• Developed the deployment groups for Informatica code migration across various environments

Environment: Informatica 9.6.1(Repository Manager, Admin Console, Designer, Workflow Manager Workflow Monitor), SQL, Oracle 11g, Toad, SQL server, SQL agent, SQL Assistant, TIDAL, XML Files, Agile/Scrum, UNIX.

Confidential

ETL-Informatica Developer

Responsibilities:

• Coordinated with the business analysts and users to understand business and functional requirements, and to implement the same into an ETL design document.
• Analysis of releases data load in to the data warehouse for creating reports for business, using Informatica power center.
• Extracted data for multiple sources or records in a single pass
• Worked on data, locations, orders, products, and transactions data.
• Maintained ETL exception as per business specification
• Tested the mappings and fixed the bugs as per QA bugs and working on Unit testing.
• Involved in Informatica Code Migration across various Environments

Environment: Informatica Power Center Designer 9.5.1, Informatica Repository Manager, SQL, Oracle 10g, AutoSys, Flat files, UNIX and SQL developer.