SUMMARY

• 7 years of IT experience in Analysis, Design, Development, Testing, Implementation and Support of Data Integration Data Migration Projects using Informatica Power Center & Informatica Cloud (IICS).
• Experienced in working with various relational data bases like Oracle, Teradata, Db2, My Sql and SQL server also used Sales Force & SnowFlake.
• Extensive experience in ETL (Extraction, Transformation and Loading) of data using Informatica Power Center from heterogeneous sources like Flat files (Fixed width, delimited), XML files, Relational databases.
• Extensive knowledge in SDLC (Software Development Life Cycle) and executed projects in Waterfall and Agile methodologies.
• Strong understanding of Dimensional Modeling, Star, Snowflake Schema, OLAP and DW concepts.
• Extensive knowledge in RDBMS concepts and Relational and Dimensional Data modeling.
• Worked closely with the data stewards to get data quality project requirements.
• Experienced in understanding the Project scope, Dependencies, Risks and provide estimations.
• Experienced in coordinating and leading onsite - offshore development model.
• Created complex mappings using transformations like Source qualifier, Expression, Aggregator, Joiner, Look up, Normalizer, SQL, Union, Update strategy, Stored Procedure, Filter, Router, XML Generator and Parser, Java Transformations.
• Co-ordinated guided and leads the teams effectively in technology migration from Informatica 9.6.1 to 10.2.
• Created Informatica Cloud mappings using Data Replication Task, Data Synchronization Task & Mapping Task.
• Migrated Power Center Mappings to Cloud using Power Center Task.
• Used Mass Ingestion Task to do heavy loads in Cloud.
• Created several Cloud mappings as part of POC to extract and load the data into snowflake.
• Experienced with Teradata utilities like BTEQ, M-LOAD, F-LOAD, F-EXPORT, T-PUMP & TPT and populate Teradata database tables.
• Expertise in analyzing the source data systems for better understanding the business requirements, designing optimal ETL design.
• Developed technical specifications of the ETL process flow, High level and Low-Level Design and Source to Target mapping documents.
• Designed and Developed Audit, Control and balancing process.
• Strong experience in handling Slowly Changing Dimensions (SCD) and Change Data Capture (CDC).
• Experience with Informatica Advanced Techniques - pushdown optimization, session partitioning.
• Extensively involved in creating reusable objects to standardize Informatica code and to bring down the development and testing efforts.
• Expertise in developing the flexible ETL code for maintenance and future enhancements by adopting parameterization.
• Extensively involved in Optimization and Tuning of mappings and sessions in Informatica by identifying and eliminating bottlenecks at Source, Transformations, Target layers.
• Experienced in setting up Shared Informatica infrastructure and UNIX platform in co-ordination with Infrastructure partner team.
• Extensively involved in writing Unix Shell Scripting programs like Source file validations, Files upload/Download to/from remote server, Source/Target Files Archival/purge requirements and to run ETL batch jobs from UNIX using PMCMD command.
• Experienced in scheduling of ETL jobs using diff scheduling tools Maestro, Autosys, Control-M.
• Independently perform complex troubleshooting, root-cause analysis and provide solution to fix defects.
• Experienced in writing sql queries using OLAP functions to improve the performance of the queries.
• Experienced in creating and using Stored Procedures, Functions, Views and Materialized views.
• Extensively involved right from Project engagement to till Production Warranty support of the project.
• Prepared Project support handover document and transitioned to Support team to ensure smooth execution of the project in Production.
• Generated warning and Error reports and shared with Business users to further analysis.
• Supported and guided Testing and Business users while SIT, UAT in progress and obtained sign off from SIT, UAT Teams.
• Extensively involved in generating automated alerts to Business users and Email notifications as per Business requirement.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Team player, Motivated, able to grasp things quickly with analytical and problem-solving skills.

TECHNICAL SKILLS

ETL: Informatica Power Center 10.2/ 9.6.1/9.5.1 /9.1.1/8.6.1 , IICS(Cloud)

Database: Oracle, IBM DB2, Sql Server, Teradata, My Sql, Sales Force, Snowflake

Tools: TOAD, SQL developer, Sql Assistant, Rally, Service Now

Languages: SQL, PL/SQL, Java, Unix Shell Scripting

Operating Systems: Windows, Linux, Unix

Data modeling tools: Erwin, Microsoft Visio

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Sr. Informatica Developer

Responsibilities:

• Worked closely with the business teams to understand the requirements along with Business Analyst & ETL Team.
• Involved in the discussions with data modelers to review the design of the data model and to create database tables.
• Involved the in creating the technical design documents along with Business Analyst and design walk through with data architects.
• Developed the informatica mappings using Source Qualifier, Expression, Joiner, Look up, Sql, Router, Union, Normalizer, Stored Procedure transformations.
• Provided informatica training to team and guided them as and when necessary.
• Extracted data from various sources Oracle, My Sql, Flat Files and loaded into Teradata.
• Used Teradata BTEQs to load data from staging to base database.
• Used Teradata Utilities - M-Load, F-Load, F-Export, T-Pump & TPT both at scripting level and along with Informatica connection.
• Involved in doing performance tuning (Using Explain Plan) of long running Teradata BTEQs in prod environment as part of the support team.
• Generated error and warning reports to help business teams for further analysis of data.
• Tuned Informatica mappings to increase the through put using various performance tuning techniques.
• Created reusable objects /mapplets to standardize Informatica code and to bring down the development and testing efforts.
• Created store procedures, Functions, Views as part of the business logic implementation.
• Reviewing the Code during Peer review which is developed by the team members and provided feedback.
• Involved in test data preparation for SIT, UAT phases.
• Created Informatica Cloud mappings using Data Replication Task, Data Synchronization Task & Mapping Task.
• Migrated Power Center Mappings to Cloud using Power Center Task.
• Used Mass Ingestion Task to do heavy loads in Cloud.
• Created several Cloud mappings as part of POC to extract and load the data into snowflake.
• Involved in Deploying the Informatica code to test and production environments.
• Provided estimations for the ETL Tasks.
• Participated in daily stand up calls and kick off meeting sessions at the begin of each iteration and Retrospective meetings.
• Worked with the Scheduling/Operations teams for scheduling the ETL jobs in Maestro.
• Supported ETL Prod environment during warranty phase using trouble tickets.

Environment: Informatica Power Center 10.2, Informatica Cloud (IICS), Oracle, My Sql, Flat Files, Sales force, Snow Flake, Teradata 16/15, Linux, Perl, TOAD, Teradata SQL Assistant, WinSCP, Putty, Rally.

Confidential, San Antonio, TX

Sr. Informatica Developer & Data Analyst

Responsibilities:

• Developed internal and external Interfaces to send the data in regular intervals to Data warehouse systems.
• Extensively used Power Center to design multiple mappings with embedded business logic.
• Involved in discussion of user and business requirements with business team.
• Performed data migration in different sites on regular basis.
• Involved in upgrade of Informatica from 9.5.1 to 9.6.1.
• Created complex mappings using Unconnected Lookup, Sorter, and Aggregator and Router transformations for populating target tables in efficient manner.
• Attended the meetings with business integrators to discuss in-depth analysis of design level issues.
• Involved in data design and modeling by specifying the physical infrastructure, system study, design, and development.
• Extensively involved in performance tuning of the Informatica ETL mappings by using the caches and overriding the SQL queries and also by using Parameter files.
• Developed complex SQL queries to develop the Interfaces to extract the data in regular intervals to meet the business requirements and extensively used Teradata Utilities like M - load, F- Load, TPT, BTEQ and Fast Export.
• Analyzed session log files in session failures to resolve errors in mapping or session configuration.
• Written various UNIX shell Scripts for scheduling various data cleansing scripts, loading process and automating the execution of maps.
• Created transformations like Expression, Lookup, Joiner, Rank, Update Strategy and Source Qualifier Transformation using the Informatica designer.
• Created mapplet and used them in different mappings.
• Worked on Flat Files and XML, DB2, Oracle as sources.
• Written PL/SQL Procedures and functions and involved in change data capture (CDC) ETL process.
• Implemented Slowly Changing Dimension Type II for different Dimensions.
• Involved in Informatica, Teradata and oracle upgrade process and testing the environment while up gradation.
• Worked with Informatica version Control excessively.
• Experience in using SVN as version control for migration.
• Written Unit test scripts to test the developed interfaces.
• Managed enhancements and coordinated with every release with in Informatica objects.
• Provided support for the production department in handling the data warehouse.
• Worked under Agile methodology and used Rally tool one to track the tasks.
• Written thorough design docs, unit test documentation, Installation, and configuration guide documents.
• Performed bulk data imports and created stored procedures, functions, views, and queries.

Environment: Informatica Power Center 9.6.1/9.5.1 , Oracle 10g, DB2, Flat Files, XML, Teradata 14/12, Unix/Linux, TOAD, Teradata SQL Assistant, WinSCP, Putty, SVN, Rally.