SUMMARY:

• 8 years of IT experience with extensive Data warehousing implementations using Informatica Power Center, SSIS, PL/SQL,T - SQL, Data stage, Quality Stage,Informatica data analyst, Tableau and SQL.
• IT experience in all aspects of SDLC process: Requirement analysis, time estimate, functional specification, design, development, testing, migration and maintenance.
• Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Experience in Data Extraction, Data Migration Data Profiling, Scorecard preparation, Data Cleansing, Data Standardization, and Data De-Duplication.
• Sharing profiles with business analysts for their analysis on defining business strategies in terms of activities such as assigning matching scores for different criteria etc.
• Defined ETL Standards, ETL process, batch processing framework, bulk loading, historical data and change data capture, implementation process, identifying re-usability.
• Strong experience on Data Warehouse concepts, ETL, OLAP, OLTP, Star Schema, Snowflake, Fact & Dimensions tables, Conceptual, Physical & Logical Data Modeling.
• Experience in implementing complex business rules by creating user defined functions, re-usable transformations and mapplets using Powercenter.
• Strong Experience in Performance Tuning Informatica 10.x/9.x/8.x mappings and job scheduling.
• Hands on Creating Reference Table using Informatica Analyst tool as well as Informatica Developer tool.
• Provided accurate data analysis and reporting for business decision-making.
• Experience in creating Tableau reports.
• Completed trainings in Informatica MDM and Microstrategy along with Hands-on.
• Strong Experience in PLSQL,T-SQL, Stored Procedures, Packages, Views and Functions.
• With Outstanding leadership abilities, able to coordinate with Offshore/Onshore model and direct all phases of project based efforts while managing, motivating and leading project teams. Worked in Agile Scrum based projects.

TECHNICAL SKILLS:

• ETL and BI Tools
• Informatica Power Center 10.x/9.x/8.x, Tableau, Microstrategy,Data Stage 8.5Quality stage 8.5,SSISJob Scheduler
• Autosys11.3/11.6, Informatica scheduler, UC4,Crontab
• Databases
• SQL Server 2016/2012/2008, MySQL, MS Access, DB2, Oracle
• Programming
• C/C++, Java,MS SQL, PL/SQL, T-SQL, Phython
• Operating Systems
• Windows, MSDOS, UNIX
• Web Technologies/Script
• HTML, XML, JavaScript, VB Script, UNIX Shell Scripting, Batch scripting
• Application Packages
• MS Office, Service Now
• Data Modeling: Visio, Erwin
• Testing and Tracking tools
• QC, SharePoint, Visual Studio

PROFESSIONAL EXPERIENCE:

Confidential, Radnor, PA

Informatica Developer/Consultant

Responsibilities:

• Interacted with the Business team to understand the requirement and problem areas then created technical specification.
• Working as Onshore Lead and managing Offshore Team on coordinating issues and helping resolves issues to the client
• Assisted in building the ETL source to Target specification documents by understanding the business requirements
• Developed mappings that perform Extraction, Transformation and load of source data into Derived Masters schema using various power center transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, lookup, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy to meet business logic in the mappings
• Reusable transformations and Mapplets are built wherever redundancy is needed
• Performance tuning is performed at the Mapping level as well as the Database level to increase the data throughput
• Designed the Process Control Table that would maintain the status of all the CDC jobs and thereby drive the load of Derived Master Tables.
• Used various user defined functions, reusable transformations, mapplets and concurrent workflow executions.
• Created appropriate indexes depend on the table situation and requirement.
• Created workflows, worklets and designed dependency among them using workflow manager. Concurrent workflow execution.
• Extensively worked with batch scripts for parsing and moving files and even for re-creating parameter files in post-session command tasks.
• Created Reusable Transformations and Mapplets to use in Multiple Mappings and also worked with shortcuts for various Informatica repository objects.
• Migration of Informatica code from DEV to TEST environments in Informatica by creating deployment groups, folders, applying labels, creating queries in the Informatica Repository Manager.
• Built sales balanceing report using VBA scripting.
• Developed database triggers in order to enforce complicated business logic and integrity constraints and to enhance data security at database level.
• Built different validation criteria, created Rules and mapplets to analyze the data.
• Scheduling of Informatica workflows and SQL stored procedures using Autosys Scheduler.
• Performed Data Quality Checks, Cleansed the incoming data feeds and profiled the source systems data as per business rules.
• Excellent experience in Data mining with querying and mining large datasets to discover transition patterns and examine financial data.
• Knowledge of creating reports in Tableau.
• Performed root cause analysis on failures. Resolved performance tuning related issues and queries
• Prepared Business required documents, Prepared test plan documents, test cases, Test scripts for Development & Migration project and tested accordingly
• Take part in daily standup and scrum meetings to discuss the project lifecycle, progress and plan accordingly, which is the crux of Agile SDLC

Environment: Informatica Powercenter 10.1/9.6, Microsoft SQL Server 2016/2012/2008, Microsoft T-SQL, Oracle 11g,Batch scripting,VBA Scripting, Autosys 11.3/11.6, SQL

SDW (Spend Data Warehouse)

Informatica Lead Developer

Confidential

Responsibilities:

• Analyze the business requirement and create ETL logic to extract data from flat files, XML files and relational tables coming from vendors, transform and load data in the data warehouse.
• Created Mappings to load data using various transformations like Source Qualifier, Sorter, Lookup, Expression, Router, Joiner, Filter, Update Strategy and Aggregator transformations.
• Worked on staging the data into work tables, cleanse, and load it further downstream into dimensions using Type 1 and Type 2 logic and fact tables which constitute the data warehouse
• Imported xsd file to create the xml source to load data from XML file.
• Created Reusable Transformations and Mapplets to use in Multiple Mappings and also worked with shortcuts for various Informatica repository objects.
• Worked with re-usable sessions, decision task, control task and Email tasks.
• Imported xsd file to create the xml target and create the Hierarchical Relationship and normalized views.
• Created complex Batch scripts for various set of actions in the SFT (Secure File transfer) like upload and download files.
• Created VBA script to generate dynamic parameter file.
• Developed VBA script to schedule Informatica workflows and validate Incoming file.
• Unit test and SIT performed on the Informatica mappings created.
• Migration of Informatica code from DEV to TEST environments in Informatica by creating deployment groups, folders, applying labels, creating queries in the Informatica Repository Manager.
• Take part in daily standup and scrum meetings to discuss the project lifecycle, progress and plan accordingly, which is the crux of Agile SDLC
• Troubleshoot the QA defects and bug-fixes and SIT in a timely manner to make the release window possible.
• Provide post release/production support.

Environment: Informatica Powercenter 9.1.1, Microsoft SQL Server 2008, FileZilla, VBA scripting, Windows Batch script, SQL

COE Offerings and Frameworks

Informatica Developer and Lead

Confidential

Responsibilities:

• Primarily worked as a designer and developer in creating complex Stored Procedures, Triggers and Functions.
• Designed and implemented Data Integration accelerators.
• Working as a developer in creating complex Stored Procedures and Functions.
• Working on Informatica Mapping POCs for few stored procedures.
• Helping team members in understanding the design and implementing the same
• Involving in designing and developing UNIX shell scripts.
• Involved in writing complex Queries to meet some of the generic business scenarios

Environment: Informatica Powercenter 9.1.1, Oracle 11g, UNIX Shell Scripting, SQL, PL/SQL

Custonect

Informatica Developer

Confidential

Responsibilities:

• Created technical design specification documents for Extraction, Transformation and Loading Based on the business requirements.
• Involved in High level design (HLD) and Low level design (LLD) documents
• Created a wrapper script for Data Base objects to help the support team for migrating objects.
• Developed logical data models and physical data models using ERwin.
• Designed and developed source to target data mappings. Effectively used Informatica Best Practices / techniques for complex mapping designs.
• Query tuning and SQL Query override used in Source Qualifier transformation to pull historical data from database not earlier than the given date i.e. the change data capture (CDC).
• Worked with wide range of sources such as delimited flat files, MS SQL server and Oracle databases.
• Designed various mappings using transformations like Lookup (Connected and Unconnected), Router, Update Strategy, Filter, Sequence Generator, Joiner, Aggregator and Expression transformations.
• Developed reusable transformations and Mapplets.
• Developed PL/SQL stored procedures for source pre load and target pre load.
• Developed Store procedure and Informatica sessions to create error and performance report. And also developed job for reject handling.
• Created Shell Scripts to execute the sessions using pmcmd command line interface.
• Used techniques like source query tuning, Partitioning and caching lookups to achieve effective performance in less time.
• Supported the Quality Assurance team in testing and validating the Informatica workflows.
• Involved in Unit testing and system integration testing and even conducted peer reviews.
• Designed and developer UC4 jobs to Scheduled Informatica jobs and UNIX scripts at required frequency.

Environment: Informatica Power center 9.5.1, Oracle 11g, SQL,PL/SQL, MS SQL server 2008,UC4,Unix Shell scripting, WinCVS