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)

Programming Languages: Unix Shell Scripting

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

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

Big Data: HDFS, Hive and SQOOP

IBM Mainframe: COBOL/JCL/VSAM/MVS-OS/IBM DB2/File-Aid, ADABAS, Natural

PROFESSIONAL EXPERIENCE

Confidential, Norfolk, VA

Informatica Developer

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

Environment: ETL Informatica Powercenter Databases MS SQL Server

Confidential, Kansas City, Missouri

Informatica Developer

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.

Environment: ETL Informatica Powercenter Databases MS SQL Server

Confidential, Colorado Springs, Colorado

Informatica Developer

Responsibilities:

• Documented user requirements, Translated requirements into system solutions and developed implementation plan and schedule.
• Extracted data from relational databases DB2, Oracle 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

Environment: ETL Informatica Powercenter Databases DB2, Oracle

Confidential, Franklin, TN

System Analyst

Responsibilities:

• Documented user requirements, Translated requirements into system solutions and developed implementation plan and schedule.
• Extracted data from relational databases DB2, Oracle 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.

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

Confidential, USA

Technical Lead

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

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

Confidential

Senior Software Engineer

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

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