SUMMARY

• 10+ years of experience in Informatica and databases, 8+ years of experience in Data warehouse concepts
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch
• Excellent in writing SQL queries in Databases SQL Server,Oracle,Teradata, and DB2
• Experience in Oracle and MS SQL Server environments using functions, SQL, Confidential - SQL and PL/SQL
• Extensively worked on Data extraction, Transformation and loading data from various sources like Oracle, SQL Server,XML,Mainframe and Flat files
• Extensively worked in UNIX environment, file transfers,NDM, job scheduling and shell scripting.
• Good knowledge in interacting withData Transformation B2B, Informatica Data Quality (IDQ) & AddressDoctor
• Good knowledge in different analytical processing OLTP,OLAP,ROLAP and MLOAP
• Involved in Performance/ Query tuning. Generation /interpretation of explain plans and tuning SQL to improve performance
• Strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center Designer and Workflow Manager
• Strong expertise in Health care domain knowledge, Specialized in Gathering Requirements from Users, Documenting Functional specifications, Source to Target mappings, Gap Analysis, Impact analysis and Root Cause Analysis
• Good knowledge in SDLC (Software Development Life Cycle), through phases of business requirements, technical architecture, design specification, implementation, deployment and documentation
• Involved in various Project Management activities like SOW Preparation, Develop Project planning and Schedule, Resourcing, Estimation, Schedule Team Meetings, Track Project Progress, Status Reporting, Client Visit Preparation, Project ManagementReview with Leadership, Continuous Risk Identification and Mitigation plan
• Strong experience in Client interactions and understanding Business Application, business data flow and data relations.
• Maintained and built good relationship with Customers and Program Stakeholders, handled many client presentations on Project Metrics
• Immense experience in Proposing and Implementing innovative ETL-DWBI solutions, Developing, Enhancing and Maintaining Operational information
• Managed customer relationship throughout the life cycle of the project by instilling customer confidence, tracked through customer feedback
• Experience in Technical leadership and Management for large projects from Requirements Gathering through final implementation of the project
• Defining Business Process; identifying the risks, doing Risk Analysis and providing baseline acceptance criteria and deliverables
• Effective Communication Skills with excellent verbal and written skills, especially with regards to presentations to both technical and non-technical audiences

TECHNICAL SKILLS

Tools: Informatica 9.6, Informatica IDQ,Informatica DT, Autosys and CA ESP Scheduling tool

Databases: Oracle, SQL Server, Teradata and Netezza

Programming: UNIX Shell Script, Confidential -SQL and PL\SQL

PROFESSIONAL EXPERIENCE

Confidential

Environment: s - Informatica PowerCenter 9.6, Oracle, NDM,UNIX & Autosys

Sr ETL Developer

Responsibilities:

• Convert the functional requirements into technical document as per the business standards
• Developing the ETL logics and the data maps for loading the tables
• Working with XML Schemas on industry standard payment files pain001,002 and pain008
• Designed and developed Infa mappings, workflows and tasks, monitored sessions, exported and imported mappings and workflows
• Develop Codes using Informatica using file as input and send the output file has XML(Pain001& Pain008)
• Perform IUT testing and support all environments till Production
• Develop Unix Script to do automation on the on the NDM script and alert to PB to inform about the delay and rejects on the WIRES and ACH payments
• Writing customize query and stored procedures for the UI interface to help end users

Confidential

Environment: s - Informatica PowerCenter 9.6, Informatica B2B Data Transformation Oracle, UNIX & Autosys

Sr ETL Developer

Responsibilities:

• Convert the functional requirements into technical document as per the business standards
• Analyze the existing code and do the impact analysis and give estimation for the code change
• Developing the ETL logics and the data maps for loading the tables
• Designed and developed Infa mappings, workflows and tasks, monitored sessions, exported and imported mappings and workflows
• Develop Codes using Informatica and build a Data Warehouse (DW) to enable meaningful data analysis
• Perform various levels of testing to ensure data quality
• Develop Autosys JIL codes based on the requirement needs
• Develop Unix Script to do automation on the manually work and also writing script based on the requirements
• Worked with Informatica B2B DT to integrate message formats such as SWIFT and EDI with informatica mappings

Confidential

Environment: s - Informatica PowerCenter 9.5/9.0.1, Informatica IDQ AddressDoctor IBM Netezza, Sql, UNIX & ESP

Sr ETL Developer

Responsibilities:

• Convert the functional requirements into technical document as per the business standards
• Analyze the existing code and do the impact analysis and give estimation for the code change
• Developing the ETL logics and the data maps for loading the tables
• Supporting all production application in Datawarehouse, working on process improvement and accomplish performance tuning on long running jobs in production
• Designed and developed Infa mappings, workflows and tasks, monitored sessions, exported and imported mappings and workflows
• Develop Codes using Informatica and build a Data Warehouse (DW) to enable meaningful data analysis
• Involve in enhancing the quality source data (Netezza and Mainframe) and integrating it to existing Business Intelligence and Data Warehouse Model
• Perform various levels of testing to ensure data Quality
• Worked with Informatica IDQ AddressDoctor to identify the risk ratio on the collateral.
• Monitoring Production jobs in ESP scheduling agent and resolve issue when we have failures in Production on rotation basis
• Involve in Project Plan which gives details on completion of each deliverables
• Working with offshore to make the work done and also perform the code review
• Manage Change Control implementation and coordinate daily, monthly production job releases and reruns.

Confidential

Environment: s- Oracle,PL/SQL, & Unix

Sr ETL Developer

Responsibilities:

• Convert the functional requirements into technical document as per the business standards
• Analyze the existing code and do the impact analysis
• Created the database objects like views and functions
• Involving in modifying various existing packages, procedures and functions in PL\SQL
• Wrote SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database

Confidential

Environment: s - Sql Server, Informatica 9.5

Sr ETL Developer

Responsibilities:

• Designed & Created the Process to do data profiling on the problematic data
• Validated that design meets requirements and function according to technical and functional specifications
• Validating the problematic customer data to ensure the data consistent between all tables and applications
• Involved in extensive data validation using SQL queries
• Extensive experience in writing and executing scripts for data validation and verifying of the data integrity between the tables
• Worked as the first-level escalation point for problems related to the offshore team

Confidential

Environment: s - Teradata, IBM DB2, UNIX and Informatica 9.0

Sr ETL Developer

Responsibilities:

• Project Leadwith hands on experience in Requirement gathering, design, development, testing, review and deployment of code
• Designed various mappings for extracting data from various sources involving flat files and relational tables
• Various kinds of the transformations were used to implement simple and complex business logic.
• Used Designer to create source definitions, design targets, create mapping and develop transformations
• Scheduling Sessions and Batches on the Informatica Server using Informatica Server Manager/Workflow Manager
• Took part in the meetings with Clients in US, Vendor and understood various process plans, business process, and delivery process
• Responsible for performing code review before deploying into the QA environment
• Promptly escalate issues, which affect product delivery and quality that are beyond scope of influence and report same to reporting manager
• Supported end users for UAT Testing

Confidential

Environment: s- Oracle, Unix,Toad and Informatica 8.6

Sr ETL Developer

Responsibilities:

• Designing and creating data validation for Oracle data warehouse using Informatica ETL tool
• Creating data mappings to extract data from different source Databases, transform the data using ETL Informatica Transformations then load to Oracle data warehouse
• Prepared Unit test cases for the Informatica mappings
• Imported data from various Sources transformed and loaded into Data Warehouse Targets using Informatica

Confidential

Environment: s - Teradata,Unix,Toad and Informatica 8.6

ETL Developer

Responsibilities:

• Developed Informatica mapping involving medium and complex logic
• Preparation UAT Support and, Unit case document preparation
• Involved in development and unit testing of Informatica Power Center mappings and Workflows.
• Developed SQL scripts and Shell scripts to generate reports from Teradata database
• Developed file comparator script in KSH, to give the difference between the two files
• Export and Import data using Teradata Fast export ad Fast Load Utilities

Confidential

Environment: s - Oracle, PL\SQL,and Informatica 8.6

ETL Developer

Responsibilities:

• Extensively Involved in Business requirements gathering and analysis of the source data
• Writing stored procedures and building packages in Oracle
• Backend coding and designing tables
• Aggressive unit testing of the system
• Extensively involved in integration testing
• Interacting with customer for new requirements and critical issues
• Wrote many consistency queries and generic patches, to find and correct the data mismatch
• Customization on existing screen on ERP product
• Design using internal ERP tool Ramco Virtual Works
• Developed and enhanced the ETL mapping using various transformations based on business requirements

Confidential

Environment: s- Sql server 2005, Confidential -Sql, and Informatica 8.6

ETL Developer

Responsibilities:

• Writing stored procedure, functions and views in SQL Server
• Creating jobs and scheduling in Sql server agent
• Daily Back up monitoring and job monitoring in Sql Server
• Involved in Data Purging Activity
• Aggressive unit testing of the system
• Extensively involved in integration testing
• Interacting with customer for new requirements and critical issues
• Wrote many consistency queries and generic patches, to find and correct the data mismatch
• Developed and enhanced the Informatica ETL mapping using various transformations based on business requirements
• Design using internal ERP tool Ramco Virtual Works