SUMMARY:

• Over 7+ years of IT Experience and Technical Expertise on Data Warehousing, Data Modeling, ETL and Business Intelligence tools.
• Created detail ETL Standards documents for Design, Development, Release Management and Production Support
• Created detail ETL Migration Processes for Informatica and Abinitio
• Design and Develop Reusable Common objects shared across various Repositories.
• Expertise in Data Profiling and Data analysis in Enterprise Data Warehouse environment
• Extensively involved in saving the Teradata Space program and contributed to save 2 TB space by analyzing and re - writing the staging logics.
• Experience with Teradata utilities like Fast load, Fast Export, Multi Load, TPUMP & TPT.
• Extensive experience in gathering business requirements and convert it into a logical model
• Extensive experience in Analysis, Design, Development, Implementation and Documentation of ETL solutions using Informatica and Abinitio.
• Hands on experience in Informatica Power Center 9.1.0, Abinitio (GDE 3.3.2), UNIX Programming and familiar with Hadoop Technologies.
• Extensive experience in Scheduling tools Control M and IBM TWS
• Involved in the full Project Life Cycle (SDLC) of the Data Warehouse projects.
• Extensive experience on Agile Methodology of Delivery in DW/BI
• Experienced with Multiple Databases including Teradata & DB2.
• Experience in validating the data consistency between Source System - DW.
• Experience with full life cycle of DW/BI Projects
• Involved in conducting KT sessions to the other vendors/client users.
• Strong development and analytical skills, proficiency in root cause data analysis.
• Strong knowledge in Business Intelligence, Data warehousing, Dimensional modeling, Star Schema, Snowflake Schema and OLAP concepts
• Having good analytical skills, systematic approach, and quick adaptability to new technologies and new working environment
• Excellent organizational skills and ability to prioritize workload
• Having Strong Domain knowledge in Banking and Retail financial services
• Commitment to achieving corporate goals. Able to establish priorities and adapt quickly to changing needs

TECHNICAL SKILLS:

Languages/Database: Shell Script, DB2, Teradata, Hadoop

ETL Tools: Informatica, Abinitio

Scheduling Tools: Control M, Tivoli

Operating Systems: Unix/Linux, Windows

Software Delivery Methodologies: Waterfall, Agile

Other: SVN, JIRA, Confluence, SharePoint, Microsoft Office, Microsoft excel, WinSCP, FTP Transfer, Putty, Teradata SQL Assistant

PROFESSIONAL EXPERIENCE:

Confidential - Columbus, OH

Ab-initio & Hadoop ETL Application Developer

Ab-initio Responsibilities:

• Involved in requirements analysis
• Understanding the Business requirement and come up with data Transformation logic.
• Ensure data integrity between the various source tables and relationships.
• Designing scripts, Flowcharts and data flow diagrams.
• Work with BSA to ensure the FSD is in sync with Business requirements.
• Create technical specification document based on FSD
• Create ETL Mapping and Graphs based on Technical Specification Document
• Build Balancing reports as per the business requirements.
• Create complex graphs, workflows for final installation and release to the client
• Debugging the data in case of data issues by using Ab-initio Debugger.
• Created Unix Scripts for some of the ETL’s as per the requirement.
• Design Ab-inito Jobs scheduling in Control M based on business flow.
• Ensure best practices and standards included in Design development.
• Creating Source DDLs.
• Preparing SQL Queries for testing the data. It includes Data Warehouse, Pre-Stage Testing, Balancing and comparing the data.
• Creating connection strings for connectivity with database.
• Maintaining the quality of the ETL Solution to achieve the customer satisfaction.
• Developed business rules for cleansing/validating/standardization of data.
• Defined System Trust and Validation rules for the base object columns.
• Completed Sor registration and intake forms, Ingestion for more than 50 files into Confirmed zone with all validation
• Involved in production deployment planning and implementation.
• Taking care of generating extracts for support activities.
• Worked on migration activities as migration engineer.
• Worked on TWS migration for entire ETL jobs to Control M
• Having strong knowledge on SQL
• Developing Views based on Business requirement
• Performance tuning for Ab-Initio graphs
• Responsible for the On-boarding process involving Knowledge Transfer, knowledge building, presentations and code walk-through.

Environment: Informatica 9.1, Ab-Initio, HDFS, Horton Works, Teradata 13, Teradata Sql Assistant, Power Exchange, WinSCP, Putty, HP Quality Centre, Control M, SVN, MS Office, Windows, Unix

Confidential

Informatica ETL Application Developer

Responsibilities:

• Code development as per JPMC SOR factory model
• Validate the data using the JPMC Audit frame work
• Done Multiple ways of code testing
• Code Deployment to higher environments using JIRA, ITSM tools
• Understanding the logic provided in the mapping documents that is to be implemented in ICDW architecture as per the JPMC standards
• Informatica ETL Code development for Business layer as per the understanding
• Cross review of the ETL code as per the Standards
• Helping team members in critical technical issues
• Worked on Tool Database access for all team members using RSAM and EURC
• Working on scenario testing with QA team to validate Business cases
• Creating & Scheduling the jobs in Control-M tool
• Providing value added services to client
• Prepared Micro design documents for L2 and L3 Teams
• Analyzing the sources, transforming data, mapping the data and loading the data into targets using Informatica Power Center Designer.
• Used various transformations like Source Qualifier, Joiner, Lookup and router, Filter, Expression and Update Strategy.
• Extracted data from Flat files, Db2, SQL Server and Oracle to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse.
• Created and Configured Workflows and Sessions to transport the data to target Oracle warehouse using Informatica Workflow Manager.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Defined Target Load Order Plan for loading data into Target Tables.
• Used Debugger to test the mappings and fixed the bugs.
• 24/7 production on-call support on rotational basis
• Documented Informatica mappings in Excel spread sheet.

Environment: Informatica 9.1, Teradata 13, Teradata Sql Assistant, Power Exchange, WinSCP, Putty, HP Quality Centre, Control M, SVN, MS Office, Windows, Unix

Confidential

Ab-Initio ETL Application Developer

Responsibilities:

• Analyzing the requirement and understanding the Requirement specifications.
• Understanding of Existing Data mart from Ab-Initio system to Migrate and build each logical part of existing system and provide through and comprehensive view to end user.
• Preparing the Reverse Engineering sheets by analyzing the Abinitio graphs.
• Preparing Mapping Documents.
• Performed Reverse engineering on existing graphs and stored procedures to know their present functionality and in turn to know where specific enhancements are to be applied.
• Preparing Unit Test cases and testing the application.
• Worked in QC to help testing team to write test cases.
• Involved in data analysis, developing new set of mappings, sessions and workflows according to the client requirements.
• Fine-tuned Transformations and mappings for better performance.
• Handled unit testing and worked extensively with testing team to help in semantic testing, UAT before delivering to the client.

Environment : TWS, DB2, WinSCP, Putty, Ab-Initio, MS Office, Windows, UNIX