PROFESSIONAL SUMMARY:

• Around 10+ years of experience in implementation and supporting post Production of Data Warehousing / Data Migration, ETL, OLAP client /server applications.
• Have 3+ Years of experience in Data Warehouse Testing.
• Strong experience in implementing Data warehousing/Data migration techniques from the scratch Using ETL tools such as Informatica 9.1/8.6/7.3 , IDQ which involves source code customization, testing, debugging and maintenance of complex systems.
• As a Sr ETL consultant, Provided technical consulting and guidance to development teams for the design and development of highly complex or critical ETL architecture.
• Identifies opportunities for new architectural initiatives; makes recommendations on the increasing scalability and robustness of ETL platforms and solutions.
• Performed short and long term strategic business activities - by developing, enhancing and maintaining operational information and models.
• Worked on Oracle to Netezza migration.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, and Sequence Generator.
• Determines organizational strategies for data integrity validation processes. Establishes policies and best practices for optimizing ETL data throughput/accessibility.
• Good experience in Banking, Health Care, Insurance & IME domains.
• Experience in Oracle, DB2, and Teradata, Netezza databases and extensively worked in Autosys, UNIX, SQL, PL/SQL programming.
• Expertise in writing SQL Queries using Oracle, SQL Server and Teradata in validating data into Data Warehouse/ETL applications.
• Individual contributor to the Project as a Technical member.
• Knowledge on Performance Tuning in Informatica.
• Expertise in translating business requirements to technical specification documents (HLD & LLD) by carefully analyzing the systems.
• Knowledge on Informatica MDM.
• Good experience in fast paced Agile Environment.
• Good understanding of Business Processes and Data Warehousing Concepts.
• Quick learner with a desire to work in a team oriented environment.
• Excellent communication, interpersonal and team building skills with eagerness to learn new technologies and domain knowledge

SKILL:

Data Warehousing ETL: Informatica Power Center 9.x/8.x/7.x, Data Mart, FACT & Dimensions tables.

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagrams, Power Designer, Visio

Databases: Oracle 12c/11g/Exadata, MS SQL Server 7.0/2000/2005/2016 , DB2

Tools: HP Quality Center 9.2/ALM, TOAD for Oracle 12.6/12.5/9.7 , Toad for SQL Server 6.5, Git Stash, Autosys

Reporting Tools: Business Objects, OBIEE

Environment: UNIX, Windows 2000/NT.

Domain Knowledge: Banking and Financial Services, Health Care, IME

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Informatica Lead Consultant

Responsibilities:

• Worked with Data Management team, Business Analysts & Consumers in analyzing and understanding the metadata reporting requirements.
• Developed mapping based on the mapping specification document that indicates the source tables, columns, data types, transformation required, filters, business rules, target tables, target columns and their data types.
• Created MOI (Metadata Object Inventory) for DDL, DML scripts and promotion document.
• Extensively worked with Slowly Changing Dimensions Type1, Type2, for Data Load using Informatica Powercenter for incremental changes from MlinQ (Metadata Lineage Quality tool).
• Created the Autosys jobs along with dependencies using JIL scripts and scheduled jobs.
• Responsible for best practices like naming conventions, performance tuning, error Handling and error reprocessing.
• Performed Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems per user requirements.
• Created Stored Procedures, Functions and extensively used the SP transformation in writing many scenarios as per the requirement.
• Validated the end 2 end Metadata Lineage for ATLAS ETL across all product lines.
• Used Tortoise Subversion (SVN) Repository folders for versioning check in and check out of all ETL code.

Environment: SQL Server 2016, Oracle 11g, Informatica Power Center 9.6.1, Jira Code, TortoiseSVN, Autosys, Toad for SQL Server 6.5.0, Toad for ORACLE 12.9.0

Confidential, Boston, MA

ETL Consultant

Responsibilities:

• Understanding the existing Essbase system and creating a design for the new setup.
• Carried out systems design, feasibility, application based studies to recommend a cost effective cloud solution.
• Encryption of restricted data, certificate based authentication discussions with Anaplan team.
• Estimation of timelines based on the complexity and dependencies.
• Design meeting with the end users
• Setting up Secure Agent servers for each project.
• Working on SAP sources and integration with Informatica Cloud
• Creating Technical Design Documents.
• Using Export/Import for lists which are created in Anaplan.
• Use File IO to insert/update/delete data in Anaplan.
• Creating IBM Tivoli jobs to trigger each task automatically as per the frequency.
• Performing migration activities and creation of migration documents for each object.
• Developed mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Creating a landing area to extract data from different sources such as ODS, SAP ECC, SQL Server.
• Writing transformation logic and cleansing rules and capturing them in TDS.
• Creating unit test cases and performing sanity checks on the data loaded into Anaplan
• Performed extensive unit testing on the mappings and Accessing Anaplan to check if data is loaded properly or not

Environment: Informatica Power Center, Informatica Cloud, Anaplan Cloud, SQL Server, SAP ECC, IBM Tivoli, Informatica IDQ.

Confidential, Phoenix, AZ

ETL Developer

Responsibilities:

• Analyzed tech spec and discussed with Lead if there are any discrepancies or modifications needed in the spec
• Attended weekly status meetings.
• Interacted with the Business Representatives to understand the requirements and determine the best approach for timely delivery of information.
• Building Reports according to user Requirement.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.
• Prepared Technical Design documents and Test cases.
• Coordinate with Oracle DBA and Unix Admin to achieve better dB performance and identify performance bottlenecks.
• Developed several complex mappings in Informatica, variety of Power Center transformations, Mapping Parameters, Mapping Variables, Mapplet Parameter files in Mapping Designer using both the Informatica Power Center and IDQ.
• Developed mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Involved in:
• Creating profiles and sending those to DQ's.
• Developing the ETL Detail Design Documents for each Process.
• Designing ETL Jobs(Using Informatica as ETL Tool)
• Creating Detail Design Document with Mapping Specifications.
• Performed extensive unit testing on the mappings and Accessing SAP to check if data is loaded properly or not.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Created various Process flows for data loading from source to target.
• Extensively used Informatica Debugger for testing the mapping logic during Unit Testing.

Environment: Informatica Power Center 9.5.1, Oracle 11g, SAP 7.3, Quality Center

Confidential

Sr ETL Consultant

Responsibilities:

• Analyze functional design document and meet with the business users for additional information needed.
• Create Technical Specification document based on the Functional Design Document provided by the business analyst.
• Generate DDLs scripts for the Data model and make sure that the naming convention is as per the standards of the CA IT requirements.
• Responsible for designing, developing and testing of the ETL strategy to populate the data from various source systems (Flat files, Oracle, SAP).
• Created Quality Center tickets to deploy ETL design from DEV to QA and subsequently, to PROD
• Created Informatica Mappings for extraction, transformation and loading of Data from heterogeneous sources to target. Performed Source-Target Mappings.
• Created different Informatica mappings for loading the data into target database. eg. Filter, Expression, Joiner, Router, Aggregator, Sequence Generator and Lookup.
• Developed complex mappings in Informatica to load the data from various sources using different transformations.
• Helped the conversion by minimizing the manual intervention and maximizing data accuracy with the use of Informatica tool during execution and validation of reports.
• Prepared Data reconciliation docs once data moved to new environment in each cut over.

Environment: Informatica Power Center 9.5.1, Oracle 11g, SAP 7.3, Quality Center

Confidential

Sr ETL Developer

Responsibilities:

• Worked closely with the Business Analysts to understand the Data requirements, definitions, and business rules to be implemented.
• Gathered business rules and requirements of different Lines of Business for the ETL process
• Involved in code review process and Code migration.
• Worked along the migration of Oracle to Teradata project where the existing Data Marts have been migrated from Oracle to Teradata environment
• Prepared the required application design documents based on functionality required.
• Developing Mappings as per given design, and raising issues where ever problem arises.
• Unit Testing the ETL’s with test data and Involved in peer reviews.
• Optimizing performance for session taking huge data and amount.
• Code changes and Coding new programs - Enhancements.
• Direct interaction with client through status calls and emails at all stages.
• Extracted data from Oracle and DB2 then used Teradata for data warehousing.
• Supported migration of ETL code from development to QA and then from QA to production.
• Responsible for creating mappings and transforming existing feeds into the new data structures maintaining client standards utilizing Router, Lookups Connected, Unconnected, Expression, Aggregator, Update strategy transformation.

Environment: Informatica Power Center 9.1, Oracle 11g, DB2, TERADATA

Confidential, Los Angeles, CA

ETL Developer & QA

Responsibilities:

• Analyzing the user specification/Client requirement documentation.
• Developed Mappings in Informatica and Reports in OBIEE.
• Execution of Unit test cases and tracking the Defects.
• Involved in fixing the SIT and UAT defects raised by the testing team within the timelines.
• Involved in developing shell scripts, PL/SQL Procedures for the applications
• Conducting KTs and technical sessions for new entrees into the team
• Participated in review meetings and status meetings & Communicate with clients to gather requirements
• Reviewing the requirements sent by the Client / Onsite Coordinators.
• Created documentation for technical and supports point of view.
• Extensively interacted with the developers and users to resolve technical issues and tracked defects.
• Tested Informatica Mappings and worked with Staging area to validate the data with Sql queries
• Experience in maintaining support documents, Test Plans, QA Sign off Documents and Maintaining Weekly Status Reports.
• Programmed largely in SQL to generate the necessary reports.
• Involved in Testing of reports by extracting the SQL generated by OBIEE and executed them in backend and validated them in QA and PROD environments.

Environment: Informatica Power Center 8.6, Oracle, OBIEE

Confidential

PL/SQL Developer & QA

Responsibilities:

• Analyzing the user specification/Client requirement documentation
• Developed scripts to load data in oracle.
• Study and analysis of the mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types
• Execution of Unit test cases and tracking the Defects.
• Developed SQL Queries for Back-end testing/Database testing and performed end to end testing.
• Validated the source system data with the staging data using SQL and Pl/SQL scripts.
• Reached Testing Goals by doing Data Completeness, Data transformation, Data Quality, Performance and Scalability
• Involved in identifying the defects and developed Defect Tracking report using Mercury Quality Centre which involved Bug life cycle.
• Provided daily and weekly status reports.
• Validated the Target data with reference to the requirement documents.

Environment: Oracle

Confidential, Los Angeles, CA

QA

Responsibilities:

• Analyzing the user specification/Client requirement documentation
• Developing Mappings as per given design, and raising issues where ever problem arises.
• Unit Testing the ETL’s with test data and Involved in peer reviews.
• Participated in review meetings and status meetings.
• Tested Informatica Mappings and worked with Staging area to validate the data with Sql queries.
• Validated the source system data with the staging data using SQL and Pl/SQL scripts.

Environment: Oracle

Confidential, Atlanta, GA

ETL Developer

Responsibilities:

• Responsible for analyzing, designing and developing ETL processes using Informatica for building, deploying, and managing an enterprise data warehouse
• Created and scheduled sessions and workflows to perform data loading
• Involved in preparing TSD, IPD documents, Low and High Level Design documents and Unit Test Documents for the ETL jobs.
• Involved in fixing the SIT and UAT defects raised by the testing team within the timelines.
• Involved in developing PL/SQL Procedures for the applications
• Reviewing the requirements sent by the Client / Onsite Coordinators
• Code changes and Coding new programs - Enhancements
• Conducting KTs and technical sessions for new entrees into the team
• Hands-on software development, enhancement and production support
• Direct interaction with client through status calls and emails at all stages
• Developed and created Mappings for the specified hierarchies of the Tables
• Involved in Data Cleansing process and implemented effective Exception handling process to have the correctness of Data.

Environment: Informatica PC 7.1, Oracle, Netezza