SUMMARY

• Around 7 + years of software experience in Client Server Applications Design, Development, Implementation, Upgrade and Maintenance.
• Strong knowledge in OLAP Systems, Kimball and Inmon methodology and models, Dimensional modeling using Star schema and Snowflake schema.
• Worked on databases Oracle, Teradata, SQL Server, DB2, and Netezza.
• Extensive experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica PowerCenter Tools.
• Extensively worked on Informatica Designer, Workflow Manager and on Informatica Webservices.
• Experience integrating various data sources like Teradata, SQL Server, Flat Files into the data warehouse.
• Good experience in Data Cleansing, Data profiling and Data Analysis.
• Excellent knowledge and experience in Technical Design and Documentation.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Cursors.
• Expertise in developing and maintaining overall Test Methodology and Strategy, Documenting Test Plans, Test Cases and editing, executing Test Cases and Test Scripts.
• Experience in PERL and UNIX Shell Scripting (Korn & Bourne) on UNIX & Linux platform.
• Having good experience in Performance tuning of SQL and PL/SQL scripts
• Experience in UNIX shell programming.
• Expert in understanding the data and designing/Implementing the enterprise platforms like Hadoop Data lake and Huge Data warehouses.
• Excellent analytical, programming, written and verbal communication skills with ability to interact with individuals at all levels.

PROFESSIONAL EXPERIENCE

Confidential, Omaha, NE

Sr.ETL - Informatica Developer

Responsibilities:

• Worked closely with data population developers, multiple business units and a data solutions Engineer to identify key information.
• Interaction with business partners to understand the business, gather requirements and translate them into technical design documentation.
• Designed Complex Informatica mappings with transformations such as Aggregator, Expression, Joiner, Filter, Source Qualifier, Union Transformation, connected/unconnected Lookups, Update Strategy, Stored Procedure, Web services, HTTP, Java Transformation and Router Transformation to transform and load the data from and to flat files and relational tables.
• Involved in developing the technical documents from functional specifications.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager. Also created various tasks such as command task, email task, timer tasks, Event wait and Event Raise tasks in the workflow manager.
• Involved in writing UNIX shell scripts in AWK to extract data files and to load the NCPDP/ X12 837 data files to SQL Server database.
• Involved in Analysis, Meeting with Business Partners in Agile Development team.
• As per Change requests (CR) migration of objects in all phases (DEV, QA and PROD) of project and trained developers to maintain system when in production.
• Used secure file transfer protocol (sFTP) method to securely transfer files between vendors and also designed file handling mechanism to encrypt/decrypt files for security purpose.
• Used Autosys scheduling tool for maintain schedules for all the batch jobs and file tarnsfers.
• Performed Tuning to identify and eliminate bottlenecks occurred to increase the performance.
• Performed data quality analysis to validate the input data based on the cleansing rules.
• Performed unit testing on the Informatica code using the Informatica Debugger and by manually checking through SQL Queries.

Environment: Informatica PowerCenter 9.6.1, UNIX, SQL Server, NCPDP Flat Files, JIRA, Teradata, HP Quality Center.

Confidential, St Louis, MO

ETL - Informatica Developer

Responsibilities:

• Extracted data from various databases like Oracle, Netezza, Teradata and load it into SQL Server DB.
• Developed various transformations like Source Qualifier, Sorter transformation, Joiner transformation, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the data into target table.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Used Sever manager for session management, database connection management and scheduling of jobs to be run in the batch process
• Involved in Analysis, Meeting with Business Partners in Agile Development team.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data
• Written documentation to describe program development, logic, testing, changes and corrections.

Environment: Informatica PowerCenter 9.6.1, JIRA, UNIX, Oracle 10g, DB2, SQL Server, Flat Files, Autosys, Teradata, PL/SQL, Netezza.

Confidential, Dublin, OH

ETL developer

Responsibilities:

• Assist in converting user requirements into high level and detailed technical specifications.
• Develop ETL mappings using Informatica.
• Write AWK/UNIX scripts to perform data cleansing and manipulation.
• Load flat files into SQL Server enterprise data warehouse.
• Document test plans for testing individual components, performs integration testing of the system, and help with creation of user acceptance test criteria prior to production system deployments. Utilizes test director tool to document and execute test cases as appropriate.
• Handle user requests for data extractions using SQL plus analysis tools.
• Facilitate user training and system appreciation sessions, creating MS Excel spreadsheets and MS PowerPoint presentations to highlight system features and showcase sample data.
• Schedule production system deployments, and support the system through initial stages to ensure stability of business processes that depend on the computer system.

Environment: Informatica PowerCenter, Teradata, Flat Files, Oracle, Sql Server, Netezza and PL/SQL, Autosys, UNIX.

Confidential

Informatica programmer

Responsibilities:

• Used Informatica Power Center Server manager to create sessions, batches to run with the logic embedded in the mappings.
• Troubleshoot new and existing systems for maximum performance.
• Fine-tuned Transformations and mappings for better performance.
• Worked with analysts and data source systems experts to map requirements to ETL code.