SUMMARY

• 4 yearsof IT Experience in Designing, Development, Administration, Implementation of DataWarehouse&Datamarts withInformatica Power Center 10.2.0/10.1.0/9.6.1/9.5.1/9.1.1/8.6.1/8.1.1 , Teradata, OLTP and OLAP using Data Extraction, Transformation, Loading and Analysis in various domains likeRetail, healthcare,and Telecommunication.
• Extensive experience in requirements gathering from business users to create Functional Specification Document (FSD), logical and physical data models.
• Experienced in working withInformatica PowerCenter10.x/9.x/8.x versions and databases likeOracle, SQL Server, Netezza, DB2, SAP HANA and Teradata.
• Experienced in working loading data from SAP HANA to Snowflake.
• Experienced in migration of the data from Netezza to S/4 HANA.
• Strong knowledge of understanding Data Modeling.
• Comprehensive experience of working with Type1, Type2 methodologies for Slowly Changing Dimensions (SCD) management.
• Experience in working with XML files, fixed width, Excel, and delimited flat files.
• Strong Experience in Data Analysis, requirements gathering, code development, System Integration Testing (SIT) and Unit testing.
• Good understanding of Data warehouse concepts, principles,approaches,Datamart,Star&Snowflake Schema, Fact/Dimension tables and Normalization/De normalization.
• Experience in SQL Tuning of the relational databases and worked extensively with Stored Procedures, Triggers, Cursors, Indexes and Functions.
• Excellent Informatica Administration skills like installing & configuring InformaticaPowerCenter, maintainingsecurity,codedeployment, servermaintenance.
• Experience in Working under Waterfall, Agile methodologies, and completeknowledgeofSDLC including Requirement analysis and gathering, Project Management, Design, implementation, development, and Testing.
• Good Exposure in Business Intelligence tools and other ETL tools.
• Ability to meet deadlines and handle pressures coordinating multiple tasks in project environment, excellent communication, interpersonal, analytical skills.
• Ability to learn and assimilate to new challenges and advanced technologies.
• Teamwork and Effectiveness to grasp things quickly.
• Supported after hours and on - call support.

TECHNICAL SKILLS

ETL Tools: Teradata 15.v/14.v, Informatica Power Center 10/9.6.1/9.5/8.6/8.1/7.1.

Databases: Snowflake, SAP HANA, Oracle 11g/10g/9i/8i, MS-SQL Server 2014/2008/2005/2000 , Netezza, IBM DB2 and MySQL

Tools: TOAD, MS VISUAL STUDIO, SQL *PLUS, Hyperion and ERWIN.

Scheduling Tools: ControlM, Autosys, Tivoli Workload Scheduler (TWS) and Tidal.

Programming: UNIX, Shell Scripts, Java, SQL, PL/SQL, T-SQL and XML

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

ETL Developer

Responsibilities:

• Responsible for successful execution of multiple ETL applications
• Strong ETL data integration experience using Informatica Power Center 9.x, 8.x
• Strong knowledge of working in Agile (SCRUM), Waterfall and SDLC Methodologies.
• Good knowledge of Data warehouse concepts and principles (Kimball/Inman) - Logical Modeling, Physical Modeling, dimensional data modeling, fact and dimension tables, Star Schema, Snowflake schema, SCD (Type1, Type2 & Type3), Surrogate keys, Normalization/De normalization.
• Proficient in SQL, UNIX Shell scripting and scheduling tools like Wok Load Manager, Autosys (JIL)
• Extensive experience in developing Job Information Language (JIL) Scripts for scheduling Informatica Jobs in Autosys Scheduling tool.
• Experienced in designing high performing ETLs in a complex Data Warehouse, Data Marts and Analytics Environments.
• Informatica and Teradata Certified consultant.
• Excellent ability in using Teradata utilities (BTEQ, FAST LOAD, MLOAD, FASTEXPORT). Good knowledge of performance tuning in Teradata
• Extensive experience in creating UNIX Scripts.
• End-to-end Deployment activities (Creating project folders, creating Labels, Baseline UNIX files using GitEye Deployment Groups and code movement to different environments).
• Responsible for day-to-day failures, migrations, break fixes
• Initiation of CRQ process, implementation of changes, post implementation review and CRQ close out / handover
• Responsible for the project management throughout the entire project lifecycle, including technical support to team, managing shift rotation plan, on need basis weekend support plan.
• Resolved impediments, interpersonal issues to work towards a harmonious work environment
• Protect team from over-commitment, manage backlog, prioritize resolution of defects/bugs
• Empowered teams to self-organize and grow cross-functionality
• Timely status communication to all stakeholders
• Track and communicate team velocity and workload balance

Environment: InformaticaPower Center 9.6.1, Oracle 11g, SQL Server, Netezza, Tortoise SVN, Unix Shell scripting,Autosys.

Confidential

ETL Developer/Production Support/Data Analyst

Responsibilities:

• Extensively worked on Power Center Client Tools like Power Center Designer, Workflow Manager, and Workflow Monitor.
• Analyzed the source data coming from different sources and worked on developing ETL mappings/mapplets.
• Extracted data from Relational databases, Legacy Systems, XML files and Flat files to Oracle database using Informatica Power Center.
• Made use of various Designer transformations like Source Qualifier, Connected and Unconnected Lookups, Expression, Filter, Router, Sorter, Aggregator, Joiner, Normalizer, Rank, Sequence generator, Union and Update Strategy transformations.
• Created Parameter files and validation scripts, Created Reusable and Non-Reusable command task in Workflow Manager.
• Created Sessions, command task, reusable Worklets and workflows in Workflow Manager.
• Extensively used SQL Overrides in Lookups, Source filter and Source Qualifiers
• Loaded data from S/4 HANA to Snowflake, modified existing ETLs pointing to Snowflake application and created brand new ETLs.
• Created multiple workflows to load history data and involved in data validations between SAP HANA and Snowflake.
• Involved in requirementsgathering directly from business, prepared design document and end to end development of ETL Jobs.
• Involved in developing complex mappings using various S/4 SAP and non-SAP sources systems (Netezza,Flat files, SQL server), transforming the data according to business requirements using IDOCS, BAPI's and RFC.
• Extensively involved in migration of the data from Netezza to CAR and S/4 HANA.
• Corrected the errors and rejection log after every job execution.
• Responsible to deliver assigned object on time and meeting SLAs for reporting Tickets.
• Familiar with synonym virtualtables in HANA.
• Worked with business in testing the data and functionality of process.
• Designed all the test cases to provide support to all system and perform unit testing.
• Created reusable MFT scripts which sends invalid data to business users accordingly.
• Provided production support and worked with end user to resolve data issues.
• Provided Data to the Micros POS systems from the S4HANA system.
• Provided support during hyper care and system Go-live.
• Provided off hours operational support as needed and involved in KT sessions with offshore team.
• Created multiple jobs in tidal and maintained.

Environment: InformaticaPower Center 10, SAP HANA, Netezza, Unix Shell scripting, Tidal.

Confidential

ETL Developer/Production Support

Responsibilities:

• As a part of ETL development team and production support, created multiple workflows from EPIC to database and supported business by addressing production issues.
• Was involved in SQL server database upgrade and resolved upgrade issues by involving with other team.
• Was involved in performance tuning of existing workflows and supported them.
• Thorough understanding of Control-M scheduling tool: scheduled and monitored many workflows.
• Acted as liaison between reporting and application development by resolving data inconsistency.
• Addressed data related issues being as production support.
• Thorough understanding of Epic and clarity dictionary: involved in modification of workflows due to EPIC decommissioning.
• Involved in using post and pre SQL commands in Informatica power center.
• Involved in developing complex mappings in Informatica power center by using different types of transformations like Connected/unconnected lookup, expression, SQL, Sort, Expression.
• Analyzed and documented newly created & existing workflows.
• Was involved workshop with business and reporting team: gathered requirement and designed solutions.
• Wrote shell and SFTP scripts in Unix.
• Involved in coding, testing, implementing, debugging and documenting the complex programs.
• Used the Data Masking transformation to change sensitive production data to realistic test data for non-production environments.
• Designed and developed complex ETL mappings by making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Wrote Informatica ETL design documents, establish ETL coding standards and perform Informatica mapping reviews.
• Extensively worked on Power Center Client Tools like Power Center Designer, Workflow Manager, and Workflow Monitor.
• Analyzed the source data coming from different sources and worked on developing ETL mappings/Mapplets.
• Extracted data from Relational databases, Legacy Systems, XML files and Flat files to Oracle database using Informatica Power Center.
• Heavily skilled in data management operations including data sourcing/acquisition, data integration, data analytics and data dissemination practices.
• Created mappings for Type1, Type2 slowly changing dimensions (SCD) / complete refresh mappings.
• Extensively used various Data Cleansing and Data Conversion functions like LTRIM, RTRIM, TO DATE, Decode, and IIF functions in Expression Transformation.
• As a mutual resource of Reporting and Integration team worked on developed SSRS reports, acquired knowledge on Tableau.

Environment: InformaticaPower Center 9.6.1, Oracle 11g, SQL Server, Netezza, Tortoise SVN, Unix Shell scripting, Control-M.