SUMMARY

• 6 years of IT experience in all phases of Software Development Life Cycle (SDLC) which includes User Interaction, Business Analysis/Modeling, Design, Development, Integration, Planning and testing and documentation in data warehouse applications, ETL processing and distributed applications.
• Expertise in using ETL Tool Informatica Power Center 8.x/9.x/10.2 (Mapping Designer, Workflow Manager, Repository Manager and ETL concepts.
• Extensive knowledge in RDBMS, Business Intelligence and Data Warehousing Concepts with emphasis on ETL and System Development Life Cycle ( SDLC ).
• Hands on experience working on Waterfall Model as well as Agile Model, implementation of various sprint.
• Interacted with end - users and functional analysts to identify and develop Business Requirement Documents (BRD) and transform it into technical requirements.
• Designed and developed complex mappings to move data from multiple sources 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, and Stored Procedure from varied transformation logics in Informatica.
• Worked with Teradata various utilities like Fast Load and Multi Load and Teradata Parallel transporter and highly experienced in Teradata SQL Programming .
• Expertise in tuning the performance of Mappings and sessions in Informatica and determining the Performance bottlenecks.
• Having strong hands on experience in extraction of the data from various source systems ranging from Mainframes like Flat Files, VSAM files, etc. to RDBMS like Oracle, SQLServer, Teradata etc.
• Extensively used multiple Slowly Changing Dimension SCD-Type1,2,3 technique in ETL Transformation.
• Expertise in OLTP/OLAP System Study, Analysis, E-R diagram, developing Dimensional Models using Star schema and Snowflake schema techniques used in relational, dimensional and multidimensional modeling.
• Worked on optimizing the mappings by creating re-usable transformations and Mapplets. Created debugging and performance tuning of sources, targets, mappings, transformations and sessions.
• Experience in Task Automation using UNIX Scripts, Job scheduling and Communicating with Server using PMCMD command . Extensively used Control M for Job monitoring and scheduling. Automated the ETL process using UNIX Shell scripting .
• Proficient in converting logical data models to physical database designs in Data Warehouse Environment and in-depth understanding in Database Hierarchy, Data Integrity concepts and Data Analysis.
• Experience in defining standards, methodologies and performing technical design reviews.
• Excellent communication skills, interpersonal skills, self-motivated, quick learner and outstanding team player.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.1/9.6/9.1

BI Tools: Cognos 9/10, Tableau 2019.3

Databases: Teradata 15, Oracle 12c/11g/10g, SQL Server 2017, MySQL

Languages: PL/SQL, UNIX Shell Scripting, SQL, PL/SQL.

Others: MS Word, MS Access, T-SQL, TOAD, SQL Developer, Microsoft Office, Teradata, View Point, Teradata SQL Assistant, Rally, JIRA, Control M

PROFESSIONAL EXPERIENCE

Confidential

ETL Informatica Developer

Responsibilities:

• Involved in the analysis of the user requirements and identifying the sources, Studied the existing environment, validating the requirements and gathering source data.
• Developed ETL design / logic in this project to load data from multiple sources using Informatica .
• Wrote SQL queries for verifying the targets data using SQL server DB.
• Created complex mapping using transformations like Joiner, Lookups, Transaction Control and Aggregator, also developed/tested mappings, sessions and workflows as per user requirements.
• Performed Data conversions using various transformations such as Source Qualifier, Filter, Router, Aggregator, Union, Lookup, Update Strategy, Sequence Generator, and Stored Procedure and configured according to Business Requirements.
• Extensively used mapplets and Reusable Transformations for reusability of mapping Logic.
• Handled versioning and dependencies of various jobs in Informatica.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements
• Created Materialized Views as per requirement
• Extensive work on the performance tuning of Oracle and ETL Process.
• Developed reusable Mapplets, Transformations, email task and command task.
• Used debugger to debug mappings to gain troubleshooting information about data and error conditions.
• Extensively worked on Informatica tuning. Customized cache, partitioned session, created session configuration for few selected sessions for cache and error login setup.
• Created Dimension Tables and Fact Tables based on the warehouse design.
• Prepared Migration Documents and Deployment Groups to deploy codes to the higher environments
• Worked on end to end development and deployment to the prod had code review meeting with admin teams and prod migration session with production support team

Environment: Informatica Power Center 10.1.1, Informatica Power Center 10.2, Microsoft Office, Control M, Oracle SQL 12c, Unix, SNV Tortoise, Jira

Confidential

ETL Informatica Developer

Responsibilities:

• Worked with business analyst for requirement gathering, business analysis and testing and project- coordination, document analysis, business process descriptions, scenarios and workflow analysis.
• Analyze business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
• Created the Detail Technical Design Documents which have the ETL technical specifications for the given functionality, overall process flow for each particular process, Flow diagrams, Mapping spreadsheets, etc.
• Worked extensively with mappings using expressions, aggregators, filters, lookup, joiners, update strategy and stored procedure transformations
• Designed and implemented ETL mappings and processes as per the company standards, using Informatica.
• Extensively worked on complex mappings which involved slowly changing dimensions.
• Developed several complex mappings in Informatica a variety of PowerCenter transformations, Mapping.
• Analyzed the existing mapping logic to determine the reusability of the code.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Created UNIX shell scripts to read/write and ftp files from and to windows servers and UNIX.
• Created Unit test plans and did unit testing using different scenarios separately for every process.
• Involved in System test, Regression test and supported the UAT for the client.
• Involved in writing BTEQ, MLOAD and TPUMP scripts to load the data into Teradata tables.
• Performing ETL and database code migrations across environments using deployment groups.
• Populating the business rules using mappings into the target tables during code development
• Involved in end-to-end system testing, performance and regression testing and data validations.
• Unit test and support QA and UAT testing for database changes.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production.

Environment: Informatica Power Center 9.6, Oracle 11g, Teradata 15, MSSQL Server 2012, Erwin 9.2, Putty, Shell Scripting, Putty, WinSCP, Notepad++, JIRA, Cognos 10

Confidential, Milwaukee, WI

ETL Informatica Developer

Responsibilities:

• Analyze business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
• Worked extensively with mappings using expressions, aggregators, filters, lookup, joiners, update strategy and stored procedure transformations.
• Developed mapping to load Fact and Dimension tables, for type 1 and type 2 dimensions and incremental loading and unit tested the mappings.
• Coordinate and developed all documents related to ETL design and development.
• 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.
• Developed stored procedures using PL/SQL and driving scripts using Unix Shell Scripts.
• Optimized the source queries in order to control the temp space and added delay intervals depending upon the business requirement for performance.
• Used Informatica workflow manager for creating, running the Batches and Sessions and scheduling them to run at specified time.
• Executed sessions, sequential and concurrent batches for proper execution of mappings and set up email delivery after execution.
• Implemented and documented all the best practices used for the data warehouse.
• Improving the performance tuning of ETL mapping/workflow
• Created Workflows, tasks, database connections, FTP connections using workflow manager.
• Responsible for identifying bugs in existing mappings by analyzing data flow, evaluating transformations and fixing bugs.
• Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement.
• Code walks through with team members.
• Created UNIX shell scripting for automation of ETL processes.

Environment: Informatica PowerCenter 9.1.1, Oracle 11g, SQL Server 2012, MySQL, Erwin 9.2, Putty, Shell Scripting, WinSCP, Notepad++, Cognos 9