SUMMARY

• Over 10 + years of IT experience in complete Software Development Life Cycle (SDLC) Data Analysis, Design, Development, Testing and UAT/Production Support in several projects in Data Warehousing &Business Intelligence (DW&BI) domain.
• Extensive experience in the Implementation of ODS, Data Warehousing and DataMart using Extraction, Transformation, Loading (ETL).
• Extensive experience working on Informatica PowerCenter / Informatica Cloud (IICS) as an ETL tool..
• Handful of working experience in Informatica DVO for comparing file to file and table to table.
• Exposure to Informatica BDM, Informatica MDM & Informatica IDQ.
• Extensively worked on ORACLE SQL & PL/SQL such as Stored Packages, Procedures, Functions, Triggers, Views, Analytical Functions, Hints, SQL UTL FILE, Pivot & Unpivot, Wif, Blocks, Cursor.
• Experience in loading data into SALESFORCE using Informatica IICS.
• Experience in Salesforce SOQL.
• Experience in AWS services like S3, DynamoDB.
• Handful of working experience in MS SQL and DB2.
• Exposure to PostgreSQL and MSQL.
• Exposure to BIGDATA Framework like Hadoop Distributed File System (HDFS), Hive Database, PIG Script.
• Well acquainted wif UNIX scripts and commands which are useful in shell scripting.
• Experience in Scripting languages like Python and NodeJS.
• Worked on building various Frameworks (Validation, Audit & Reconciliation) to ensure Data integrity.
• Experience in Agile methodology - Scrum.
• Experience in JIRA and Version One Agile Supporting tools.
• Experience in DevOps automation tools like Jenkins.
• Extensively worked in AutoSys jobs development.
• AWS Certified Cloud Practitioner.
• SNOWFLAKE Certified - Badge Workshop 1: Data Warehousing.
• Awarded as Innovation Champion of the year 2015 for Automating One to one Mapping Development, using VBA in our Business unit.
• Extensive experience in Performance Tuning for Informatica mappings and SQL Queries.
• Experience in Gap analysis and providing Gap Resolutions.
• Experience working on end-to-end projects starting from Requirement gathering till Production support.
• Have implemented Slowly Changing Dimensions (SCD) Type 1, Type 2 in the projects which I have worked on.
• Handled Up to 850 Million plus volume of Transactional data at the time of Data Migration.

TECHNICAL SKILLS:

Business Analysis/Data Analysis: Functional Requirements Gathering, Business Requirements Gathering, Process Flow Diagrams, Data Flow Diagrams, MS Access, MS Office

Database Modeling: Physical Modeling, Logical Modeling, Dimensional Modeling (Star Schema, Snow- Flake Schema, Dimensions), ER Diagrams

ETL Tools: Informatica 9.X,10.X

Databases: Oracle 11g & 12C, MS-SQL Server 2017, DB2, NETEZZA, PostgreSQL, MSQL, Snowflakes, AWS DynamoDB

Tools/Utilities: Informatica PowerCenter, Informatica Cloud IICS, Informatica DVO, AWS Console, SQL Developer, TOAD, Tectia SSH, Putty, Salesforce, AWS

Languages: SQL, PL/SQL, PYTHON, Node.Js, UNIX shell Scripting.

AWS Services: DynamoDB, S3, Lambda

Big data Framework: Hadoop( HDFS ), HIVE, PIG

Operating Systems: Windows NT/2000 Server, Sunsolaris Linux

PROFESSIONAL EXPERIENCE:

Confidential, CT

Sr. ETL Developer

Roles & Responsibilities:

• Requirement Gathering, Estimation and planning of development work using Agile Model.
• Developed Informatica Mapping to load data into ODS layer (MS SQL) wif Framework (Source File Validation, Trailer record Validation, Audit Entry, ETL Reconciliation & Business Reconciliation) to ensure Data Integrity.
• Developed Informatica IICS Mapping and Task to load data into Salesforce Customer 360.
• Developed Unix Shell scripting for creating Subset of a Source File, File Comparison.
• Developed Informatica DVO table pair for doing Business Reconciliation.
• Written complex SQL queries using correlated Analytical Functions, sub queries, joins, and recursive queries.
• Developed PL/SQL - Oracle Package for flipping the Batch date after every Successful Run.
• Worked on Performance Tuning of Informatica mappings and SQL Source Qualifier Queries.
• Created AutoSys Boxes & Jobs for batch Processing.
• Performed POC to convert text file into Multi level Nested JSON File Using Node.js and Python.
• Performed POC to load data from JSON file into AWS DynamoDB using AWS Lamada Service, Node.js and Python.
• Object Version is maintained through Bit bucket.
• Code deployment to higher region is by Jenkin’s pipeline.
• Plan delivery of work; demonstrate active leadership wifin the team and agile practices.
• Experience in working on end-to-end projects starting from Requirement gathering till Production support.

Environment: Informatica PowerCenter 10.2, Informatica IICS, MS SQL 2017, Oracle 12c,DB2, Linux, Salesforce, Informatica DVO, Informatica IDQ, Python, NodeJS, AWS DynamoDB, S3.

Confidential CT

Sr. ETL Developer

Roles & Responsibilities:

• Estimates and planning of development work using Agile Software Development.
• End to end ownership of deliveries to production - including analysis, planning, model, design, develop, code, test, debug, document and push to production
• Developed Informatica Mapping to load data from SE2 Admin system into Fixed Width Target Files.
• Written complex SQL queries using correlated Analytical Functions, sub queries, joins, and recursive queries.
• Developed PL/SQL Blocks for performing One time History Loads.
• Developed Unix Shell scripting for creating Subset of a Source File, File Comparison.
• Developed Informatica DVO table pair for doing Business Reconciliation.
• Created AutoSys Boxes & Jobs for batch Processing.
• Object Version is maintained through Bit bucket.
• Code deployment to higher region is by Jenkin’s pipeline.
• The gathered requirements were prioritized & traced throughout the product cycle.
• Code development checklist TEMPhas been created & recommendations were provided during LLD review calls.
• Experience in working on end-to-end projects starting from Requirement gathering till Production support.
• Team members were guided for smooth run of the project.
• Commitments were met successfully by providing timely resolution for issues.

Environment: Informatica PowerCenter 10.2, Oracle 12c, DB2, Linux, Informatica DVO, Informatica IDQ, AutoSys, Tectia.

Confidential, CT

Sr. ETL Developer

Roles & Responsibilities:

• Involved in Requirement gathering, business Analysis, Design for implementation of business rules.
• Coordinating tasks among the offshore team members and supporting.
• Worked on Various Enhancements from simple to Very Complex to maintain ODS, Data Warehouse and DataMart.
• Development of Complex SCD Type1 and Type 2 Informatica mappings.
• Performance Tuning of SQL Source query & Informatica Workflow to reduce the overall runtime.
• Worked on CRM Salesforce enhancement projects.
• Developing a UNIX script to fetch the relevant information from the session log.
• Involved in resolving production issues and preparing RCA document.
• Developing PL/SQL Blocks, Procedure, packages and Functions for Data migration (History Load).
• Extensively used Bulk Collections to insert and update huge volume of data into target databases.
• Wrote Complex SQL Query to achieve Very Complex Business logic using Oracle Analytical Function (LEAD, LAG, MAX, MIN, SUM, ROW NUMBER, RANK), PIVOT, UNPIVOT, LISTAGG and many functions.
• Created AutoSys boxes for Batch load.
• Experience in working on end-to-end projects starting from Requirement gathering till Production support.

Environment: Informatica PowerCenter 10.1, Oracle 12c, Linux, CRM Salesforce, MS Excel VBA Scripting, UNIX Shell Scripting, AutoSys, Tectia.

Confidential

Sr. ETL Developer

Roles & Responsibilities

• Involved in Requirement gathering, business Analysis, Design for implementation of business rules.
• Completely involved in Restructuring Data Warehouse and ODS design and Development.
• Extracted files to match wif DOL acceptance Fixed width Format.
• Involved in resolving production issues and preparing RCA document.
• Mentoring new recruits to the project internally.
• Development of Complex SCD Type1 and Type 2 Informatica mappings.
• Handled Multiple Source Systems such as Flat File, XML, JSON and different types of Database.
• Performance Tuning of SQL Source query & Informatica Workflow to reduce the overall runtime.
• Data validation between Source and Target to ensure the Data Integrity.
• Application of logic to gather the load statistics in a log table.
• Developing a UNIX script to fetch the relevant information from the session log.
• Migration of Informatica objects from Dev to QA and tan to Prod.
• Developing PL/SQL Blocks, Procedure, packages and Functions for Data migration (History Load).
• Extensively used Bulk Collections to insert and update huge volume of data into target databases.
• Wrote Complex SQL Query to achieve Very Complex Business logic using Oracle Analytical Function (LEAD, LAG, MAX, MIN, SUM, ROW NUMBER, RANK), PIVOT, UNPIVOT, LISTAGG and many functions.
• Created AutoSys boxes for Batch load.
• Used Oracle packages like DBMS STATS to collect statistics of many different kinds as an aid to improve the performance and UTL FILE to read and write operating system text files.
• Handled large volume of data load up to 850 Million using PL/SQL & Informatica.
• Taken care of DOL Broker Dealer Project Deliverables as a Tech Lead adheres to the timelines and process.
• Explored option in HDFS, HIVE and PIG
• Automated Informatica workflow creation for One to One mapping using Excel VBA which saved 400+ Development hours.
• Participated in Defect Triage.
• Reviewing the Daily Status Report & Defect Summary wif Client QA leads and highlighting the
• Project risks
• Experience in working on end-to-end projects starting from Requirement gathering till Production support.

Environment: Informatica PowerCenter 10.1, Oracle 12c, Linux, CRM Salesforce, MS Excel VBA Scripting, UNIX Shell Scripting, Hadoop, Hive, Pig, AutoSys, Tectia.

Confidential

ETL Developer

Roles & Responsibilities

• Involved in Requirement Analysis and Design.
• Developed ETL mappings as per Mapping document using Informatica PowerCenter.
• Prepared Oracle DDL & DML Scripts.
• Designed and developed Oracle PL/SQL Blocks, Procedures, Functions, and Database Triggers and involved in creating and updating Packages to meet business requirements and to handle Batch Rerun for the same Batch date
• Performed History loads.
• Developed Generic Unix Shell scripting for creating Control File used for FMH File transfer.
• Prepared Unit test cases and performed Unit testing.
• Worked wif Reporting team for Data validation.
• Coordinated wif Source teams for Integration testing.
• Involved in development of AutoSys jobs and boxes.
• Involved in Code migration activities.
• Involved in QA, UAT, Implementation & Warranty support activities.
• Performed Production job monitoring activities before the formation Operations team.

Environment: Informatica PowerCenter 10.1, Oracle 11g, Linux, Cubes, Tectia, Unix Shell Scripting, Batch scripting, AutoSys.

Confidential

RETL Developer

Roles & Responsibilities:

• Data Model the OLAP system to Develop Netezza ETL Stored Procedures for building analytical reports named SAS Views from GB’s of fact tables wif high end performances.
• Informatica was the ETL tool hosted upon NGW system, wif which gained expertise technical knowledge on Informatica tool in a stipulated timeframe.
• Gained ample amount of knowledge on UNIX Shell Scripts and worked on developing the Scripts.
• Informatica PowerCenter mappings, sessions, workflows were designed & developed.
• Oracle PL/SQL Procedures and Functions were designed & developed.
• Shell scripts were written for scheduling jobs and transferring files across network.
• Developed C# Web services to interact wif Ramco Decision work and Oracle Database.
• Stored procedures and SQL queries were tuned in accordance wif results of explain plan.
• Working on various tasks like Shell Scripting, Session Task and Event Wait.
• Scheduled job using Workflow Scheduler.
• Involved in Informatica Administration tasks like Repository Backup & Restore, installation of Informatica Server, user creation, giving privilege for users.

Environment: Informatica PowerCenter 9.5, MS SQL 2007, Oracle 11g,C# Web service, Informatica Administration Tools, Ramco decision Work Products, Putty.