SUMMARY:

• Around 9.4 years of industry experience with Informatica Power Center 9x/8x (Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager and Workflow Monitor), Informatica BDM, Informatica IDQ, Informatica MDM 10.x, expert level of skills in developing strategies for extraction, transformation and loading of data. Proficient in understanding business processes, requirements and translating them into technical requirements.
• Expertise in Delivering Responsibilities with different levels Sr. Informatica Developer, System Analyst, and Developer including Scope Definition, Estimation, requirements understanding, Creating Technical Design Document, Data modeling, Development, Testing, Implementation and Production Support.
• Good knowledge on Data Warehousing Concepts like OLAP, OLTP, Star Schema, Snow Flake Schema, Fact Table and Dimension Table.
• Expertise in preparing Technical Design Documents, Coding, Source to Target Mapping (STM), Unit Test Cases and reviewing code and design doc.
• Extensively worked on ETL Informatica transformations effectively including - Source Qualifier, Connected - Unconnected Lookup, Filter, Expression, Router, Union, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure,Java Tranformation, Transaction Control, Sorter and Sequence Generator,SQL transformation and created complex mappings.
• Experience in integration of various data sources like Oracle, Teradata, DB2, SQL Server, Flat Files, XML, Mainframe and SAP into Warehouse using Informatica.
• Experienced in Tuning Informatica Mappings to identify the bottleneck and inproving the performance of mapping.
• Developed Mappings using Type 1, Type 2 and Type 3 SCD logic to load data into Dimension table.
• Worked on Ab Initio Graph Developments and History loading from Oracle to Teradata.
• Performance tuning activities on Teradata database, applied enhanced techniques like creating Indexes or changing Indexes on the table, tuning SQL scripts by following appropriate steps using Explain Plan and step table, also performed DDL generation and database sizing activities.
• Datamovent and Backup activities using Datamover,Query Grid and Arc Main.
• Experience on Scheduling tools like Ctrl M and WLM.
• Hive and HDFS jobs implementation using Informatica BDM.
• Data profiling using Informatica IDQ and involved in Cleansing, parsing and address validations of profiles.
• Good experience in Relational Databases like Teradata, Sql Server. Teradata Level 3 Certified.
• Responsiable for Build process, movement of code from Development to Test and Test to Production through Informatica Query and Deployment group.
• Experienced in developing Test Plans, Test and Test Cases for Data Warehousing/Migration projects.
• Expertise in Support, Development, Implementation and Testing of ETL solutions involving Informatica, Shell scripting, Teradata & MySQL.
• Well versed with development and testing related activities performed in DW projects using InformaticaPowercenter 8.x/ 9.1/9.5/9.6 and Teradata12 /13.1/14.
• Extensive client/user interaction.
• A quick learner with strong analytical, functional, technical skills and possess leadership and excellent communication skills.
• Coordinating with Stakeholders &Development team.
• Analyze client’s business requirements and processes through document analysis, customer interaction and workflow analysis
• Provide input into developing and modifying systems to meet client needs and develop business specifications to support these modifications.
• Facilitate weekly meetings with clients to document requirements and explore potential solutions.

TECHNICAL SKILLS:

Operating System: Windows 10, UNIX

Languages: C, C++, SQL, Java, HTML, Python, Big Data Basics and Unix shell scripting,HDFS and Hive .

ETL Tools: Informatica Power Center 9.6/9.5/9.1/8.6 , (Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager, Workflow Monitor). Informatica Data Profiler, Informatica MDM 10.x, Ab Initio,Informatica BDM 10.1.1

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snowflake Schema, FACT and Dimensional Tables, Physical and Logical Data Modeling.

Databases: Teradata 14/15,Oracle 11 g

Database skills: Views, Materialized views, Bteq,Mload,Fload,Tpump and TPT,Hive Query .

Version Control Tools: Informatica Version Control.

DB Tools: TOAD, Teradata Sql Assistant, Teradata View Point, Unity Datamover, QueryGrid, Arc Main

Scheduling Tools: Informatica Workflow Scheduler, Cltrl M, WLM

Reporting Tool: Tableu Basics

Documentation Tools: MS Office 2010

Test Case & Defect Tracking Tool: Jira, Service Now

PROFESSIONAL EXPERIENCE:

Confidential, Georgia, Atlanta

Informatica/Teradata Developer

Responsibilities:

• Devlopement and testing of Informatica Jobs and mappings.
• Resolving day to day production failures by providing bug fixes and over riding the Teradata scripts.
• Providing Permanent Fixes for the recuuring failures by performance tuning or changing the existing code after detail Data Analysis.
• Adding Dependencies /file triggers and scheduling of the jobs using Ctrl M/WLM.
• Working on Data Quality Incidents raised by the End user.
• Incident Tracking and management using Service Now tool and creating RITM/Request for change management and Approvals
• Preparing Migration /Design documents and presenting the same in Design Review meeting for New code or Permanent Fixes.
• Co-ordination with different teams and providing handover of the developed code to the production Team.
• Development of Informatica BDM jobs and configuring the Hadoop File system.
• Modelling of tables in Hive Database and Validation/Querying using HUE ACCESS tool.

Confidential, Arizona, Phoenix

Teradata/Unix Script Developer

Tools Involved: Unity Datamover, Querygrid, Arc Main, Teradata 14, UNIX.

Responsibilities:

• Data movement from BMG server in Silas to TD1 Server using Query Grid and Data mover
• Development of Unix script to automate the process of loading 24/7.
• Creation of Metadata Tables to keep the track of the number of tables and amount of data loaded
• Creating check out scripts for Count/Hash Validation and Append/Truncate scripts for incremental loading
• Writing TD SQL statement for Upsert tables
• Move majority of data before the migration weekend and keep the scripts ready for final processing on the migration weekend before the server is sunset.
• ARC main to take back up of metadata tables.
• Validating and fixing the data wherever the count or data does not match.

Confidential, Arizona, Phoenix

Migration/Informatica Developer

Tools Involved: Teradata 15, Informatica, UNIX, Oracle, Datamover,QueryGrid.

Responsibilities:

• Requirement gathering from the business users regarding the Objects to be migrated.
• As part of H2 module involved in DDL conversion, View conversion and Data movement from Oracle to Teradata.
• Conversion on stored procedures in Oracle to Bteq in Teradata
• Creation of fload scripts for Data movent.
• Creation of BRD report and presenting the same to the client.
• Creating Informatica Worklows and Mappings for history loading of jobs using Teradata Load utilities.
• Generating Informatica PDO queries for SCD1 Jobs.
• Using indirect file list in Informatica Sessions for incremental file processing.
• Use of Datamover and query grid between Teradata systems.
• SIT/UAT Testing and Data validation.
• Data Profiling and Performance tuning of the Queries in Teradata.

Confidential

Informatica Developer

Tools Involved: Informatica Power Center 9x, IDQ, MDM, Teradata 14, Unix

Responsibilities:

• ETL Informatica Team Lead
• Development of Informatica Jobs and mappings
• Responsible for preparing Build document, production transition doc, deployment Doc and closing code review log etc.
• Get the final sign off from all the business users and migrate the code to Production
• Development of shell scripts for doing preliminary operations to the source files and prepare them to feed the ETL Informatica Process and also workflow execution and for loading the source files to EDW
• Data pull from various data sources like Oracle, Teradata, Mysql, XMl and Flat files.
• Extensive use of Push down optimization to move the ETL Informatica source code to Teradata.
• Tuning the Teradata SQL by rebuilding indexes, stats collection and analyzing the explain plan.
• Implementing data transformations using complex transformations like Java, Sql and Normalizer.
• Extensive use of Teradata load utilities like Fload, Mload,Tpump, TPT export as well as Unix scripting to implement the Bteqs and stored procedures with Informatica mappings.
• Performance tuning of the jobs to ensure that the Jobs complete within SLA time.
• Developed Mappings using Type 1, Type 2 and Type 3 SCD logic to load data into Dimension table.
• Involved in Modeling for Sharding Process from Mysql.
• Development of jobs for Ocean ingestion ( Hadoop ) from Informatica
• Fixing bugs and Data quality issues after final migration.
• Coordination with other teams and technologies to mitigate dependencies while data flow from source to MDM hub in case of any ETL/MDM job failures.
• Creation of Mappings, Hierarchy, Profiles in Informatica MDM.
• Data Security based on their Users and Roles and their accessibility to the various Business Processes
• Devlopment of mappings to move data to landing and staging tables in Informatica MDM and creation of trust and relationship processes for match making.

Confidential

ETL Informatica Systems Analyst L2 and Team Lead

Tools Involved: Informatica Power Center 9x, Teradata 14, Unix

Responsibilities:

• Worked as an ETL Informatica support Team lead and delegated responsibilities among peers.
• Daily Client Calls to discuss the SLA breached and communicating with the Business customers the reason for the delay.
• Delegating responsibilities among the peers and ensure that all the deliverables are met on time
• As a L2 analyst worked on various data quality request raised by the client on Jira .
• Preparation Of Monthly Reports and presenting the same to the clients
• Fixing bugs and data quality issues as per the request raised by the users.
• Worked on Production defects and CRs approved by Business and Technical team with minimal time period.
• Worked on migration activity for Informatica 9.5 to 9.6.
• Worked with client’s vendor partners to move the code to different environments and resolve the migration issues.
• Communicates with source system to correct the source data.
• Perform Quality assurance and review process once the build/History fix is over.
• Analyzing End to End ETL Informatica failures and providing quick resolutions to meet SLA
• Proactive monitoring of the SLA based jobs and communicating with client to discuss the delays and approvals.
• Process Automation using Unix scripting to build SLA tracker.
• Failed session List, Long Running sessions, Excel Macros, Failure Notifications by fetching Metadata from Informatica Repository.
• Analyzing repetitive failures and give recommendations to client to improve the process
• Maintaining detailed run books.

Confidential

Informatica Support Analyst

Responsibilities:

• Analyzing Informatica workflows/Mappings and providing code fixes.
• Enhancement and Support of Informatica mapping and workflows.
• Contributed in data analysis and resolving ETL failures.
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from source to target systems using Informatica.
• Provided suggestions for Informatica tuning and testing.
• Coordinating with Stakeholders/Development team/Client - committe