SUMMARY

• Over 8+ years of progressive hands - on experience in analysis, ETL processes, design and development of enterprise level data warehouse architectures, enterprise level large databases, designing, coding, testing, and integrating ETL.
• Proficient in understanding and detailing the business requirements and had experience in interacting with business users to clarify requirements and translate the requirements into technical and user stories.
• Experienced in analysing Business and Functional requirements, studying the Source systems thoroughly designing the Target by going through the Functional Specification Document and one- to- one interaction.
• Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets and Data marts and Data warehouse.
• Having experience in working with ORACLE 11g/10g, MySQL, SQL Server 2012/2014.
• Performed Unit testing, System testing, Integration testing and users for UAT and prepared test report in different phases of project.
• Created and modified UNIX Shell Scripts for ETL jobs.
• Extensive experience with Data Extraction, Transformation, and Loading (ETL) from Multiple Sources.
• Designed and developed complex mappings, Mapplets, tasks and workflows and tuned it.
• Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations like Mapplets.
• Extensively used Slowly Changing Dimension (SCD) technique in business application.
• Conducted Unit tests, Integration tests and Customer Acceptance tests (UAT).
• Working experience in Agile and Waterfall methodologies.
• Experience working with Onsite and Offshore model and while working in that project ensured proper work assignment and review.
• Domain knowledge experience on healthcare.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 8.X, 9.X, 10.X

Databases: Oracle11g/9i, SQL Server

Tools: SQL plus, TOAD, Autosys

Operating Systems: UNIX, Windows

PROFESSIONAL EXPERIENCE

Confidential

Sr Informatica Developer

Responsibilities:

• Worked in Agile Methodology, worked on story in Jira assigned on every sprint.
• Worked with different source systems such as database, Flat files.
• Worked on getting files from AWS to UNIX server using FileZilla.
• Involved in development of UNIX scripts for doing some basic operations like merging of files, removing header from files etc.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Populating the business rules using mappings into the target tables.
• Involved in end-to-end testing and data validations.
• Worked with business analyst for requirement gathering, business analysis, testing, business process descriptions, scenarios and workflow analysis.
• Created Technical Design Document from business requirements document (BRD).
• Analysed business and system requirements to identify system impacts.
• Prepared source to target mapping and conducted meetings with the business to understand data / transformation logic.
• Analysed the existing mapping logic to determine the reusability of the code.
• Created the Detail Technical Design Documents which have the ETL technical specifications for the given functionality.

Environment: Informatica Power Center 10.2, Oracle 11g, Sql Developer, Unix, Putty.

Confidential, Louisville - KY

Sr Informatica Developer

Responsibilities:

• Worked with business analyst for requirement gathering, business analysis, testing, business process descriptions, scenarios and workflow analysis.
• Created Technical Design Document from business requirements document.
• Analysed business and system requirements to identify system impacts.
• Created the Detail Technical Design Documents which have the ETL technical specifications for the given functionality.
• Prepared source to target mapping and conducted meetings with the business to understand data / transformation logic.
• Analysed the existing mapping logic to determine the reusability of the code.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Done the extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system.
• This led to better session performance.
• Performing ETL and database code migrations across Different environments (Dev->SIT->UAT->Perf-> Prod).
• Populating the business rules using mappings into the target tables.
• Involved in end-to-end testing and data validations.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production.
• Modified UNIX scripts to run informatica workflow.

Environment: Informatica PowerCenter 10.2, Tableau, SQL, Oracle 11g, TOAD, Control M, Shell scripting.

Confidential, Chicago - IN

Sr Informatica Developer

Responsibilities:

• Worked on all phases of data warehouse development lifecycle, from requirements gathering to testing, implementation, and support.
• Prepared data using ETL tool (DataStage/Informatica) to load data into different target table for multiple user groups.
• Developed charts, reports and different types of data visualizations using the data that was sent on daily basis from the database.
• Deployed the code into different environments and made it available for the different user groups as per the requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Responsible for the design, implementation, and architecture ofvery large-scale data intelligence solutions around Snowflake Data Warehouse.
• Responsible for ETL (Extract, Transform, Load) processes to bring data from multiple sources into a single warehouse environment.
• Worked with Informatica Power Center designer to develop mappings using Aggregate, Expression, filter, Sequence generator, Update strategy, union, lookup, Joiner and stored procs.
• Involved in end-to-end testing and data validations.
• Design and built ETL pipelines to automate ingestion of structured and unstructured data.
• Worked on relational databases using SQL for data extraction, management, and queries.

Environment: InformaticaPower Center 9.1, PL/SQLdeveloper, XML, Oracle 11g, Flat files, UNIX, Control-M.

Confidential

Informatica/ETL Developer

Responsibilities:

• Involved in the Execution of test cases
• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop the mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica Power Center 8.6.1, Oracle 11i, SQL Developer, TOAD