SUMMARY

• 7+ years of IT experience with expertise in analysis, design, development and implementation of Data warehouses, data marts and Decision Support Systems (DSS) using ETL tools Informatica Power Center with RDBMS like Oracle, MS SQL server, Teradata, DB2 and AWS cloud databases.
• Experience in Informatica PowerCenter10.2/9.x/8.x ( (Designer, Workflow Manager, Repository Manager ) and since last project using PowerCenter 10.2.
• Extensive exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support.
• Strong experience with Informatica tools using real - time CDC (change data capture) and MD5.
• Experience in integration of various data sources like Oracle, Teradata, SQL server, Flat files, JSON and extensive experience on Oracle and Teradata.
• Experience with Snowflake cloud data warehouse and AWS S3 bucket for integrating data from multiple source system.
• Expert in writing complex SQL queries, PL/SQL and optimizing the queries.
• Experience in developing very complex mappings, reusable transformations, sessions and workflows using Informatica ETL tool to extract data from various sources and load into targets.
• Experience in tuning and scaling the procedures for better performance by running explain plan and bulk load.
• Experience in Performance tuning of ETL process using pushdown optimization and other techniques. Reduced the execution time for huge volumes of data for a company merger projects. Heavily created mapplets, user defined functions, reusable transformations, look-ups.
• Interacted with end-users and functional analysts to identify and develop Business Specification Documents (BSD) and transform it into technical requirements.
• Worked on optimizing the mappings by creating re-usable transformations and Mapplets. Created debugging and performance tuning of sources, targets, mappings, transformations and sessions; used PDO whenever required.
• Experience in Task Automation using UNIX Scripts, Job scheduling and communicating with Server using PMCMD command. Extensively used Autosys for Job monitoring and scheduling. Automated the ETL process using UNIX Shell scripting.
• Good knowledge in Hadoop using Hive and HDFS
• Hands on experience working on Waterfall Model as well as Agile Model.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 10.2/9.6/9.0.1 , Informatica Cloud, Alteryx

Database: Teradata 15, Oracle 11g/10g, SQL Server 2014

DB Tools: MySQL, SQL*Plus, TOAD, and SQL Loader, SQL Assistant

Data Modeling: Logical/Physical/Dimensional,Star/Snowflake StarSchema, OLAP, ERWIN

Environment: WINDOWS XP/2000, Unix and Linux

Languages: SQL, PL/SQL, UNIX

Reporting Tools: Cognos 11/10, Tableau10

Other Tools: Autosys, ControlM, Rally, JIRA, Putty, WinSCP, Rally, Notepad++

PROFESSIONAL EXPERIENCE

Power BI Developer

Confidential

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Actively involved in interacting with business users to record user requirements and Business Analysis.
• Participate in the Design Team and user requirement gathering meetings.
• Develop transformation logic as per the requirement, create mappings and load data into respective targets.
• Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• Develop Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
• Develop the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source Qualifiers, and data flow management into multiple targets using Router transformation
• Performance tuning of the process at the mapping level, session level, source level, and the target level.
• Create reusable Sessions and extract data from various sources, transformed data according to the requirement and loading into data warehouse.
• Develop several reusable transformations and mapplets that were used in other mappings.
• PrepareTechnical Design documents and Test cases.
• Implement various Performance Tuning techniques.
• Use SQL tools like TOAD to run SQL queries to view and validate the data loaded into the warehouse.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Extensively working on Unit testing for the Informatica code using SQL Queries and Debugger.
• Use PMCMD command to start, stop and ping server from UNIX and create UNIX Shell scripts to automate the process.
• Improve performance testing in Mapping and the session level.
• Work with UNIX shell scripts extensively for job execution and automation.
• Coordinate with Autosys team to run Informatica jobs for loading historical data in production.
• Document Data Mappings/ Transformations as per the business requirement.
• Migration of code from development to Test and upon validation to Pre-Production and Production environments.
• Providetechnical assistance to business program users and develop programs for business and technical applications.
• Written documentation to describe development, logic, testing, changes and corrections.
• Performed data validation after the successful End to End tests and appropriate error handling in ETL processes.
• Resolving the tickets based on the priority levels raised by QA team.
• Developed Parameter files for passing values to the mappings for each type of client
• Scheduled batch and sessions within Informatica using Informatica scheduler and also wrote shell scripts for job scheduling.
• Work closely with the business analyst’s and Production Support to resolve any JIRA issue.
• Co-ordinate offshore team on daily basis to leverage faster development.

Environment: Informatica PowerCenter 10.2, Cognos 11, Putty, SQL, Oracle 12c, TOAD, Teradata 16, SQL Server 2016, Autosys, Shell Scripting, Notepad++, JIRA, Erwin 9.2, WinSCP

Confidential

Sr. Power BI Developer

Responsibilities:

• Worked with the business team to gather requirements for projects and created strategies to handle the requirements.
• Worked on project documentation which included the Functional, Technical and ETL Specification documents.
• Used Informatica PowerCenter for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Designed and developed complex mappingsusing Mapping Designer to move data from multiple sources and transformed data into a common target area such as Data Marts and Data Warehouse using Lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Normalizer, Sequence Generator, Update Strategy, Java and Stored Procedure from varied transformation logics according to the requirement.
• Prepared Technical Design documents and Test cases.
• Created Sessions and Workflows and extracted data from various sources, transformed data according to the requirement and loaded into data warehouse.
• Performed data validation, data profiling, data auditing and data cleansing activities
• Configured sessions for different situations including incremental aggregation, pipe-line partitioning etc.
• Created mappings with different look-ups like connected look-up, unconnected look-up, Dynamic look-up with different caches such as persistent cache etc.
• Created various Mapplets and re-usable transformations as part of mapping design.
• Performed Unit and Integration Testing to ensure the successful execution of data loading process.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Extensively worked on Unit testing for the Informatica code using SQL Queries and Debugger.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX Shell scripts to automate the process.
• Used PMCMD command to run workflows from command line interface.
• Improved performance testing in Mapping and the session level.
• Worked with UNIX shell scripts extensively for job execution and automation.
• Documented Mappings, Transformations and Informatica sessions.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Experience in Task Automation using UNIX Scripts, Job scheduling and Communicating with Server using PMCMD command.

Environment: Informatica PowerCenter 9.6.1, Cognos 10, tableau 9.3, SQL, PL/SQL, Oracle 11g, DB2, TOAD, SQL Server 2014, Control-M, Shell Scripting, JIRA

Confidential

Informatica Developer

Responsibilities:

• Analyze business requirements, technical specification and physical data models for ETL mapping and process flow.
• Coordinate and develop all documents related to ETL design and development.
• Performed data profiling and data cleansing, applying rules and develop mappings to move data from source to target systems
• Designed and implemented ETL mappings and processes as per the company standards, using Informatics Power Center.
• Extensively worked on complex mappings which involved slowly changing dimensions.
• Worked extensively on Informatica transformations like Source Qualifier, Expression, Filter, Router, Aggregator, Lookup, Update strategy, Sequence generator and Joiners.
• Debugged mappings by creating a logic that assigns a severity level to each error, and sent the error rows to error table so that they can be corrected and re-loaded into a target system.
• Deployed reusable transformation objects such as Mapplets to avoid duplication of metadata, reducing the development time.
• Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement.
• Responsible for identifying bugs in existing mappings by analyzing data flow, evaluating transformations and fixing bugs.
• Developed mapping to load Fact and Dimension tables, for type 1 and type 2 dimensions and incremental loading and unit tested the mappings.
• Worked onmapping performance improvementand optimizedSQLquery .
• Worked on loading of data from several flat files to Staging using Teradata FLOAD, MLOAD, and BTEQ scripts.
• Responsible for debugging and performance tuning of targets, sources, mappings and sessions.
• Optimized the mappings and implementing the complex business rules by creating re-usable transformations and Mapplets.
• Used Informatica workflow manager for creating, running the Batches and Sessions and scheduling them to run at specified time.
• Preparing Functional Specifications, System Architecture/Design, Implementation Strategy, Test Plan & Test Cases.
• Implemented and documented all the best practices used for the data warehouse.
• Created UNIX shell scripting for automation of ETL processes.
• Worked in the ETL Code Migration Process from DEV to ITE, QA and to PRODUCTION.

Environment: Informatica PowerCenter 8.6, Cognos 9, WinSCP,Oracle 11g, PL/SQL, TOAD, Putty, Control-M Scheduler, UNIX, Teradata 14, Erwin 7.5