SUMMARY

• Around 7 years of IT experience with emphasis on Business Requirements Analysis,
• Strong ETL Experience in Design, Configuration, Data Mapping, Extraction, Transformation, Loading and processing of large volumes of data using Informatica Power Center 10.2/10.1/9.6/9.5/9.1/9.0/8.6/8..0
• Extensive experience in Data Warehousing techniques for Data Cleaning, Slowly Changing Dimension (SCD) phenomenon, Surrogate Key Assignment and Change Data Capture ( Confidential ).
• Proficient with various active Transformations like (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank)
• Experienced with various Informatica client tools like Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager, Workflow Monitor and Workflow Manager
• Extensive experience with analysis profiling on existing data and identify root causes for data inaccuracies, Impact Analysis and recommendation of Informatica Data Quality.
• Worked with Teradata utilities like Fast Load and Multi Load and Tpump and Teradata Parallel transporter.
• Having strong hands on experience in extraction of the data from various source systems like Oracle 12c/11g/10g/9i/8i, Teradata 14/13/12, SQL Server 2016/2014/2012 , Confidential Netezza PostgreSQL, DB2, MySQL, Salesforce.com, Flat Files, XML Files and COBAL Files.
• Created and maintained Database Objects like Tables, Views, Materialized views, Indexes, Constraints, Sequence, Table Partitions, Synonyms and Database Link
• Created and developed complex mappings using various transformations such as Lookup, Joiner, Aggregator, Filter, Sorter, Expression, Router, Union, Rank, Update Strategy, Source Qualifier and Sequence Generator.
• Expertise in performance Tuning, identifying and resolving performance bottleneck, Indexing and Partitioning techniques on sources, targets, mappings and workflows
• Experienced in migrating Informatica mappings from Databases like Oracle, MySQL, SQL, Flat Files to SQL, Teradata, DB2, and other relational databases
• Experienced writing and modifying ETL Design Documentation, Test Results Documentation and Standard Operating Procedures (SOP) documentation.

TECHNICAL SKILLS

ETL Tools & Cloud Services: Informatica Power Center 10.2/10.1/9.6.1 , 9.5/9.1/8.6/8.0 , IDQ 10.2/ 10.1/9.5 , Power Exchange 9.5/ 9.5, MDM, Informatica Intelligent Cloud Services, Snowflakes, AWS Redshift, AWS RDS, S3, EC2, Azure SQL, Azure Data Factory, Azure Data Lake Store, Datasets, Linked Services, Pipeline

Reporting Tools: Power BI, MSBI (SSIS, SSRS, SSAS), Tableau, Cognos, OBIEE11g, Micro Strategy, Business Objects, MS Excel

Scheduling Tools: Control - M, AutoSys, Tidal, Maestro, Cron Tab, Informatica Scheduler

Databases: Teradata 15/14/13/12, Oracle 12c/11g/10g/9i/8i, SQL Server 2016/ 2012/2008 , PostgreSQL, Netezza, DB2, MySQL, Flats Files, XML files, Mainframe COBAL Files, Hadoop HDFS, Pig, Hive, BDM, Sqoop, MongoDB, Casandra

Programming Languages: C, C++, SQL, PL/SQL, Unix Shell Scripts

Web Technologies: HTML, XML

Methodologies: Agile, Waterfall

Operating Systems: Unix, Windows 2010, 2008, 2007, XP, 2000

PROFESSIONAL EXPERIENCE

Confidential, Atlanta GA

Sr ETL Developer/Tester

Responsibilities:

• Created Mapplets & Mappings with Informatica PC 10.2 using required Transformations (Source Qualifier, Normalized Transformation, XML Parser, Expression Transformation, Look ups, Router Transformation, Stored Procedure Transformation, Update Strategy Transformation, Aggregator Transformation, Union Transformation and Joiner Transformation)
• Developed and used the Pre & Post Scripts, Parameters in Informatica
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures using Informatica Power Center.
• Worked with Informatica Utilities Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer
• Used various transformations like Stored Procedure, Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement complex business logic
• Created reusable transformations to load data from operational data source to Data Warehouse and involved in capacity planning & storage of data
• Analyzed the sources, transformed data, mapped the data and loaded the data into targets using Informatica Power Center Designer
• Created a list of the inconsistencies in the data load on the client side to review and correct the issues on their side.
• Implemented performance tuning techniques on both Database (Source Query) and Informatica (Mappings, Sessions) to load the data efficiently (FLOAD, MLOAD & Fast Export) and improve batch performance
• Worked on developing BTEQ Scripts
• Configured Informatica Power Center 10.2 to load the data to Hive directly without Informatica BDM for less resource intensive jobs
• As part of process improvement, worked as Defect Preventive Champion to achieve zero defect and maintain knowledge repository by collecting Issues/Defects, Solution and Preventive actions

Environment: Informatica Power Center, 10.2, Oracle 11g, MS SQL Server 2016,Snowflakes, Microsoft Azure, Flat Files, SQL, PL/SQL, Shell Scripts, Oracle SQL Developer, Unix, Window 10.

Confidential, Springfield, MA

Sr. ETL Informatica Developer

Responsibilities:

• Interact with Business Users & Architects with Interview questions and meeting to understand the existing system (AS-IS) and new requirements (TO-DO) and prepared the BRD (Business Requirement Document)
• Prepared ETL process flow to chart key requirements for TO-DO solution
• Created Mapplets & Mappings with Informatica PC 10.2 using required Transformations (Source Qualifier, Normalized Transformation, XML Parser, Expression Transformation, Look ups, Router Transformation, Stored Procedure Transformation, Update Strategy Transformation, Aggregator Transformation, Union Transformation and Joiner Transformation)
• Developed and used the Pre & Post Scripts, Parameters in Informatica
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures using Informatica Power Center.
• Created a list of the inconsistencies in the data load on the client side to review and correct the issues on their side.
• Implemented performance tuning techniques on both Database (Source Query) and Informatica (Mappings, Sessions) to load the data efficiently (FLOAD, MLOAD & Fast Export) and improve batch performance
• Worked on developing BTEQ Scripts
• Configured Informatica Power Center 10.2 to load the data to Hive directly without Informatica BDM for less resource intensive jobs
• As part of process improvement, worked as Defect Preventive Champion to achieve zero defect and maintain knowledge repository by collecting Issues/Defects, Solution and Preventive actions

Environment: Informatica Power Center, 10.2, Oracle 11g, MS SQL Server 2016,, Flat Files, SQL, PL/SQL, Shell Scripts, Oracle SQL Developer, Unix, Window 10.

Confidential, Sacramento, CA

Sr. Informatica Developer

Responsibilities:

• Involved in requirement gathering, Design, testing, project coordination and migration.
• Project planning and scoping, facilitating meetings for project phases, deliverables, escalations and approval. Ensure adherence to SDLC and project plan.
• Analysed the business requirements and functional specifications provided by Data migration group.
• Connected source data using Informatica PowerExchange from Mainframe, Oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database.
• Used Informatica PowerCenter 9.6 for extraction, transformation and load (ETL) of data in the data migration.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Parameterized the mappings and increased the re-usability by designing and creating mapplets.
• Used Informatica PowerCenter Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Created procedures to truncate data in the target before the session run, enable and disable index.
• Created a list of the inconsistencies in the data load on the client side to review and correct the issues on their side.
• Write DB PL/SQL scripts using Oracle TOAD.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Used SSRS to generate reports and dashboards.
• Published SSRS reports to the Oracle BI self-service and troubleshoot deployment issues.
• Created hierarchies in SSRS reports using Data visualizations like Bar chart, Line chart, pie charts, forecast charts
• Created UNIX scripts for parsing and modifying data and experience in using Control-M job scheduler for automation of UNIX shell scripts and batch scheduling.
• Created tasks, sequential and concurrent batches for proper execution of mappings using task flow using shell scripts for loading data on daily, weeks and monthly basis.

Environment: Informatica PowerCenter 9.6, Oracle 11g, DB2,Flat Files, Shell Scripting, WinSCP, Control-M, Tidal, SQL, PL/SQL, T-SQL, SSRS, SQL Assistant, Toad, Linux/Unix, Windows 8.

Informatica Developer

Responsibilities:

• Involved in different phases of the project life cycle like design, development, testing and deployment.
• Prepared technical design specifications for Data Extraction, Transformation and Loading
• Extracted data using Informatica PowerExchange from Mainframe, Oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central Oracle database.
• Worked with Informatica Utilities Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer
• Used various transformations like Stored Procedure, Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement complex business logic
• Created reusable transformations to load data from operational data source to Data Warehouse and involved in capacity planning & storage of data
• Analyzed the sources, transformed data, mapped the data and loaded the data into targets using Informatica Power Center Designer
• Used Informatica Workflow Manager to create workflows, database connections, sessions and batches to run the mappings
• Used Variables and Parameters in the mappings to pass the values between mappings and sessions
• Extensively used PL/SQL, TOAD programming in backend and front-end functions, procedures, packages to implement business rules.
• Write DB PL/SQL scripts using Oracle TOAD.
• Used Cognos to generate reports and dashboards.
• Implemented restart strategy and error handling techniques to recover failed sessions
• Used Unix Shell Scripts to automate pre-session and post-session processes
• Performance tuning to improve Data Extraction, Data process and Load time

Environment: Informatica Power Center 8.6, Oracle 9i, SQL Server 2008, DB2, Flat Files, XML Files, COBAL Files, Unix/Linux, Shell Scripting, Windows 7, AutoSys, PL/SQL, SQL, Cognos, TOAD.