SUMMARY

• Over 12 + Years of IT Experience as Informatica PowerCenter Developer.
• Experience in Requirement Analysis, Requirement gathering, Functional Analysis, System Design, Process flow, Workflow Design, Test Case Analysis, Software Development Life Cycle (SDLC), System Testing, Agile methodology, Bug fixing, Application Production support, Documentation, Implementation, Production Support, Maintenance and Integration of data in different domains like Investment Banking, Insurance, Retail, Telecom and Automobile.

TECHNICAL SKILLS

ETL/BI: Informatica PowerCenter (9.x,10.x)

Languages: Unix Shell Scripting

Database: SQL Server/ Confidential /DB2/PL - SQL/T-SQL

Scheduler: Control-M, CA-7, Tidal, Autosys

Big Data: HDFS, Hive and SQOOP

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Experienced in Star-Schema and Snow-Flake data modeling, Normalization, Data Cleansing
• Hands on expertize in analyzing relational database environment using SQL, PL/SQL,T-SQL, DB2, Stored Procedures .
• Exclusively worked on Support project with SNOW as ITIL creating Incidents, change requests, Problem tickets and following up to their resolution being primary support person for entire DWH application.
• Excellent knowledge in Agile methodology of project execution (Sprint planning, Creating and updating tasks in Kanban/Scrum, Sprint retrospective meetings etc)
• Created workflows and applications in Informatica Developer and deployed them to DIS to be available for running.
• Experienced in designing complex business rules through Informatica transformations, Workflows/Worklets, Mappings/Mapplets, Test Plans, Test Strategies and Test Cases for Data Warehousing projects.
• Experienced in job scheduling using Control-M, CA-7, Autosys, Tidal
• Experience in Online and Batch Mainframe environments and production supports for both.
• Experience in working on Investment Banking, Automobile, Insurance, Medical, Retail and Telecom domains.
• Received appreciations from management for proactive improving the performance
• Quick learner and adaptive to new environments.

Confidential, Norfolk, VA

Informatica Developer

Environment: ETL - Informatica Powercenter, Databases - MS SQL Server

Responsibilities:

• Documented user requirements, Translated requirements into system solutions and developed implementation plan and schedule.
• Analyzing existing informatica data mappings/workflows and end to end business process for different loads.
• Analyzing source and target systems and end to end ETL batch process.
• Addressing Jira tickets assigned for application defects or enhancements on timely manner.
• Liaison between offshore and client for tasks assigned and representing daily standup.
• Extracted data from relational databases SQL Server
• Loaded the Data into Relational Databases SQL Server
• Managed writing test cases and test scenarios from requirement for newly added features and executing test scripts.
• Developed the Mapping, Workflow, Session/Tasks using the Informatica Power Center 10.x
• Implemented Aggregate, Filter, Router, Joiner, Expression, Lookup and Update Strategy transformations.
• Performance tuned the Informatica Mappings with the help of Pushdown Optimization
• Reverse engineering the T-SQL Stored procedures, to convert legacy ETL Process to Informatica Objects

Confidential, Kansas City, Missouri

Informatica Developer

Environment: ETL - Informatica Powercenter, Databases - MS SQL Server

Responsibilities:

• Documented user requirements, Translated requirements into system solutions and developed implementation plan and schedule.
• Extracted data from relational databases SQL Server
• Loaded the Data into Relational Databases SQL Server
• Managed writing test cases and test scenarios from requirement for newly added features and executing test scripts.
• Developed the Mapping, Workflow, Session/Tasks using the Informatica Power Center 10.x
• Implemented Aggregate, Filter, Router, Joiner, Expression, Lookup and Update Strategy transformations.
• Developed and implemented the Slowly changing Dimension Type 1 and Type 2
• Developed and implemented the Star Schema Data Mart
• Performance tuned the Informatica Mappings with the help of Pushdown Optimization
• Created the Scripts to execute the SQL Statements
• Written T-SQL Stored Procedure to used in the Pre/Post-SQL session
• Loaded data into target database using the Target Load Order Plan and Constraint Based loading
• Developed the New Data mart to support the Associate based reporting. Datamart created from Staging databases.
• Developed the New Operational Data Store (ODS) to GUI application to query the Associate Related information
• Developed the ETL process to support the migration of legacy application to Work-Center.

Confidential, Colorado Springs, Colorado

Informatica Developer

Environment: ETL - Informatica Powercenter, Databases - DB2, Confidential

Responsibilities:

• Documented user requirements, Translated requirements into system solutions and developed implementation plan and schedule.
• Extracted data from relational databases DB2, Confidential and Flat Files.
• Managed writing test cases and test scenarios from requirement for newly added features and executing test scripts.
• Developed the Mapping, Workflow, Session/Tasks using the Informatica Power Center 10.x
• Implemented Aggregate, Filter, Router, Joiner, Expression, Lookup and Update Strategy transformations.
• Automated the Year-end Tax Audit system and reporting from Ms Access to Informatica Power center
• Convert the report file (.txt) to .csv format to process audit system
• Compare the Report file(external) with the Internal report file and report the discrepancies on based on accounts, Funds
• Created and tested the SFTP connection using Sterling
• Created the Autosys jobs to schedule and execute the Informatica Workflows

System Analyst

Confidential, Franklin, TN

Environment: Mainframe - COBOL, JCL, VSAM, Natural, CA-7, ETL - Informatica Powercenter, Data Modelling, Databases - DB2, ADABAS, Confidential, MS SQL Server

Responsibilities:

• Documented user requirements, Translated requirements into system solutions and developed implementation plan and schedule.
• Extracted data from relational databases DB2, Confidential and Flat Files.
• Managed writing test cases and test scenarios from requirement for newly added features and executing test scripts.
• Served as a point of contact for the ETL testing, attend business, project and defect meetings with the development and the end-users to review and resolve the issues.
• Extensive experience in Database Design, Normalization, Selective De-normalization, Forward/ Reverse Engineering of Applications, Conceptual, Logical and Physical data modeling using Erwin
• Worked in Onsite/Offshore model and coordinated with offshore team.
• Adding requirements into Quality Centre, Mapping Requirements with Test cases.
• Documenting defects in Quality center Uploading all necessary information into Share point.
• Worked closely with UAT team.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Experienced in using IDQ tool for profiling, applying rules and develop mappings to move data from source to target systems.
• Recording, tracking and closing of defects/bugs in a systematic manner into a Defect Tracking System and preparation of bug report with bug severity and bug priority.
• Managed the Metadata associated with the ETL processes used to populate the data warehouse.
• Implemented Aggregate, Filter, Join, Expression, Lookup and Update Strategy transformations.

Technical Lead

Confidential, USA

Environment: Mainframe - COBOL, JCL, VSAM, Natural, CA-7, ETL - Informatica Powercenter, Databases - DB2, ADABAS, Confidential

Responsibilities:

• Documented user requirements, Translated requirements into system solutions and developed implementation plan and schedule.
• Managed writing test cases and test scenarios from requirement for newly added features and executing test scripts.
• Worked in Onsite/Offshore model and coordinated with onshore team.
• Served as a point of contact to attend project and defect meetings with the development and the end-users to review and resolve the issues.
• Adding requirements into Quality Centre, business Requirements with Test cases.
• Documenting defects in Quality center Uploading all necessary information into Share point.
• Worked closely with SIT team.
• Analysis of the specifications provided by the clients
• Design and Development of Mainframe applications for business needs
• Design and Development of ETL Data pipelines using the Informatica Power Center for business needs
• Database management and SQL
• Responsible for overseeing the Quality procedures related to the project.
• Handling Batch Support effectively & seamlessly.
• Carrying out effective enhancement work

Senior Software Engineer

Confidential

Environment: Mainframe - COBOL, JCL, VSAM, Control-M, Databases – DB2

Responsibilities:

• Documented user requirements, Translated requirements into system solutions and developed implementation plan and schedule.
• Managed writing test cases and test scenarios from requirement for newly added features and executing test scripts.
• Worked in Onsite/Offshore model and coordinated with onshore team.
• Served as a point of contact to attend project and defect meetings with the development and the end-users to review and resolve the issues.
• Adding requirements into Quality Centre, business Requirements with Test cases.
• Documenting defects in Quality center Uploading all necessary information into Share point.
• Worked closely with SIT team.
• Analysis of the specifications provided by the clients
• Design and Development of Mainframe applications for business needs
• Database management and SQL
• Responsible for overseeing the Quality procedures related to the project.
• Handling Batch Support effectively & seamlessly.
• Carrying out effective enhancement work