SUMMARY:

• Over 7 years of experience as experience in building Enterprise Data Warehouse, Data Marts, Operational data stores in various domains like Healthcare, Insurance, Finance, and Retail using Informatica Power centre and developer.
• Experience wif Informatica Power Centre 10.4.0, 9.x, 8.x IDQ 9.6.1, 10.1.1 MDM and Teradata, SQL server, oracle databases.
• Expertise in using Teradata database and utilities like TPT, FASTLOAD, MULTILOAD, and BTEQ scripts.
• Experience in Analysis and collecting statics on Teradata tables and Columns to improve performance Database.
• Experience in developing Complex SQL queries and PL/SQL Procedures.
• Experienced in debugging and Performance tuning of teh Informatica mappings, sessions, and workflows.
• Performed Unit testing /SIT testing and prepared testing documents as required by teh client.
• Experienced in designing/understanding of teh existing/new LDM/PDM (Logical/ Physical data model) and STM (Source to Target Mapping) documents.
• Basic Knowledge in Informatica MDM, Informatica Data Quality, Informatica Cloud, and Informatica DT Studio implementation.
• Acquired experience wif all teh aspects of SDLC (Software Development Life Cycle) like Planning, Analysis Design, Deployment, Testing, Integration and Support.
• Experience in working wif slowly changing dimensions and change data capture.
• Developed Complex database objects like Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL.
• Efficiently halped in teh Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing, and Documentation.
• Experience in Agile methodologies. Good experience in Programming language/ Structural query language (PL/SQL).
• Experience in Creating and Updating Clustered and Non - Clustered Indexes to keep up teh SQL Server Performance.
• Provided 24*7 on-call support while working on production environments and provided L3 and L2 technical support.

TECHNICAL SKILLS:

Rdbms:: MS SQL Server, Oracle and Teradata

Language: T- SQL, SQL,PL\SQL

Tools: SQL Server Management Studio (SSMS), Visual Studio, Toad, Jenkins, Udeploy.

ETL Tools: Informatica Power Center 10.4.0/10.1.1 /9.6.1/9.5.1/8.6.1/7.1.1 and Informatica BDE 9.6.1

Microsoft BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Crystal Reports 10.0 & Excel Power Pivot, Power BI, Tableau

EXPERIENCE:

Confidential, Dallas, TX

Informatica ETL Developer

Responsibilities:

• Used Informatica Power Center to extract/transform and load data from different operational data sources like Oracle, Flat files like CSV files, XML files, Cobol files, SQL server from which customers data is coming and is loaded into Teradata warehouse.
• Implemented Type 2 Slowly Changing Dimension (SCD) to access teh full history of accounts and transaction information.
• Implemented Change Data Capture (CDC) using teh MD5 function.
• Worked on Informatica command line utilities like PMCMD, PMREP.
• Responsible for teh performance tuning of teh ETL process Confidential source, target, mapping, and session levels.
• Responsible for troubleshooting bottleneck problems by creating teh indexes Confidential database level.
• Created and configured workflows, worklets, and sessions using Informatica Workflow Manager.
• Made use of session log files and workflow log files to debug errors in mappings and sessions.
• Used Mapping Parameters and Variables for reusability of code snippets.
• Worked wif version control tools like SVN and scheduler tools like autosys.
• Worked wif Teradata utilities like Multiload, FastExport, and BTEQ scripts.
• Coded shell scrips in UNIX and used UNIX tools like WinSCP.
• Supported teh testing team, UAT team and production support teams.
• Worked on complex mappings using transformations like Aggregator, Expression, Joiner, Filter, Sequence Generator, Connected and Unconnected Lookup, Dynamic Lookup, Filter, Router, Union, and Update Strategy using Informatica Power Center Designer

Environment: Informatica Power Center (PWC) 10.1.1, Teradata 16.20, Teradata Utilities, Toad for DB2, SQL Server Management Studio, Oracle 11g/12c, Oracle SQL Developer, Flat Files, .CSV, Jira, Microsoft Confluence, Autosys, Putty, WinSCP, Notepad++

Confidential, Lafayette, LA

Informatica Developer

Responsibilities:

• Involved in Business meetings to understand teh business requirement specifications and implemented teh ETL jobs using Informatica.
• Involved in developing teh source to target process and mapping documentation.
• Participated in teh review and approval of teh technical transformation requirements document used to design and build teh ETL modules in Informatica Designer.
• Designed and developed several complex mappings using various transformations like Source Qualifier, Aggregator, Router, Joiner, Union, Expression, Lookup, Filter, Update Strategy, Stored Procedure, etc.
• Prepared a best practice document to use when designing jobs to gain optimum performance by using appropriate partitioning techniques.
• Created/Enhanced Teradata Stored Procedures to generate automated testing SQLs.
• Created Understanding documentation and Release testing documentation on teh tickets handled, and documented teh issues found in a central repository.
• Involved in teh code reviews prepared by teh teams.
• Written Unit test cases and integration test cases for teh developed code.
• Code migrations from one environment (DEV-QA-UAT-PROD) to another environment like (DDL’s, views, stored procedures).
• Documented teh Unit and System Integration test results as per teh team standards.
• Developed and implemented strategies for slowly changing dimensions, surrogate key generation and for incremental data loading.
• Performed performance tuning of jobs to improve teh extraction, transformation and loading time of data.
• Created RM tickets for teh deployment of active batch jobs, creating folders in DEV, QA, UAT and PROD
• Created CM tickets for teh production deployments.
• Created Active Batch Job Plans and jobs for all teh development and scheduling teh jobs in active batch tool.
• Created production Runbooks, production Catalog etc.
• Production support for teh warranty period timeline of 30 days.

Environment: Informatica Power Center (PWC) 10.4.0/10.1.1, Teradata 16.20, Toad for DB2, SQL Server Management Studio, Oracle 11g/12c, Oracle SQL Developer, Flat Files, .CSV, Microsoft Team Foundation Server, Microsoft Confluence, Rally, Active Batch V12 Console, Putty, WinSCP, Notepad++, GitHub, Jenkins, IBM Udeploy.

Confidential, Cincinnati, OH

Senior ETL Informatica Developer

Responsibilities:

• Involved in Data Modeling using different techniques.
• Interacts wif business users to understand teh requirements.
• Created technical specification documents, STM documents, detailed ETL designs, Unit test plans, Deployment plans, Turn over documents etc.
• Implemented Type 2 Dimensions (SCD Type 2) to maintain history in teh Dimensions.
• Involved in requirement specification meetings to add/change requirement as per teh changing ETL Scenarios.
• Worked wif NoSQL database MongoDB and worked wif it to perform many different operations
• Involved in ETL architecture meetings and any new tool implementations.
• Used complex Informatica mappings to extract data from teh source system to teh Staging DB.
• Converted complex Oracle PL/SQL Packages to Informatica Mapping/Mapplets.
• Converted complex Transformation requirements to Informatica Transformations to transform teh Source data to match teh target data.
• Involved in change control meetings every week.
• Created test plans and scenarios for development unit testing and data validation.
• Performance tuned slow running mappings by using best practices like Partitioning, SQL Overrides, etc.
• Generated fixed and variable length flat files and read XML files.
• Worked on teh Teradata stored procedures and functions to confirm teh data and has load it on teh table.
• Worked on FTP commands for file transfer.
• Worked on tools like SQL developer, TOAD and DB Visualizer to write complex SQL queries.
• Developing data links and data loading scripts, including data transformations, reconciliations and accuracies
• Has a participated in all phases of Software Development Lifecycle (SDLC)
• Has advanced noledge of T-SQL and/or ANSI SQL, ETL and Data Warehousing
• Designing BI solutions wif Microsoft SQL Server R2 / 2012
• Building state-of-art reports dat deliver information in a user-friendly and efficient way
• Querying Microsoft SQL Server R2 / 2012
• Looking for root causes in case of solution failures

Environment: Informatica Power Center (PWC) 10.1.0/9.6.1, Oracle 11g, PL/SQL Developer, T-SQL, Flat Files, MS Excel 2010, MS SQL SERVER 2008, UNIX, WinSCP, MS Access, Jira.

Confidential, Carmel, IN

Senior Informatica Developer

Responsibilities:

• Used various informatica transformations in teh development of complex mappings.
• Extracted data from different heterogeneous source systems applied business logic using transformations and loaded to teh target systems using Informatica power center.
• Document designs and architect data maps, develop data quality components and establish and/or conduct unit tests
• Create/maintain design related artifacts me.e. data models, Mapping documents, architecture diagrams, data flow diagrams
• Managing SharePoint 2010, SSIS 2008 and SSAS 2008 production, test and development servers
• Evaluating data file submissions and developing/maintaining SSIS packages for ETL processes
• New development as scoped and requested by teh business
• Design data and data quality rules using IDQ and involved in cleaning teh data using IDQ.
• Used IDQ to profile teh project source data, define or confirm teh definition of teh metadata, cleanse and accuracy check teh project data, check for duplicate or redundant records, and provide information on how to proceed wif ETL processes
• Analyzed and thoroughly studied various data sources and different development environments wifin teh organization.
• Extensively worked on extracting teh data from various flat files (fixed width, delimited), applying teh business logic and tan loading them to teh oracle databases.
• Extensively worked wif Source qualifier, Filter, Joiner, Expression, Lookups, Aggregator, Router, Sequence Generator, and Update Strategy.
• Worked closely wif business for requirement gathering and to understand teh project needs.
• Interacted wif environmental team and data architects in design and implementation data models.
• Designed and developed complex mappings to load teh Historical, Weekly and Daily files to Oracle database.
• Extensively worked on data conversion and data cleansing.
• Build SQL, T-SQL queries implementing functions, packages, views, triggers, and tables written UNIX shell scripts created command task, and email task for providing teh pre-session post-session requirements for various informatica jobs.
• Provide database coding to support business applications using T-SQL
• Worked on automation of informatica job flow using autosys boxes/jobs.
• Extensively worked on basic SQL queries such as creating altering Tables, Indexes, Views also worked wif PL/SQL stored procedures. Queried various tables to get resultant datasets as per teh business requirements.
• Prepared ETL mapping documents explaining complete mapping logic.
• Prepared unit test document and performed unit testing, regression testing.
• Provided QA/UAT support while code promotion and worked wif QA's to resolve any defects if found.
• Worked wif teh Release Management Team, teh DBA Team, and teh UNIX team for smooth code productions.

Environment: Informatica PowerCenter 9.6.1/9.5, Informatica Data Quality (IDQ), T-SQL, Oracle 11g, PLSQL Developer, Flat Files, MS Excel 2010, MS Visual Studio 2010, UNIX, WinSCP, MS Access, Autosys.

Confidential

Informatica Developer

Responsibilities:

• Performed requirements gathering, developed Analysis & Design document (A&D), developed Project time line.
• Designed and developed teh ETL Mappings for teh source systems data extractions, data transformations, data staging, movement and aggregation.
• Developed standard mappings using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter for weekly, quarterly process to loading heterogeneous data into teh data warehouse. Source files include delimited flat files, and SQL server tables.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy, Union, SQL, Java and Sequence generator.
• Executed sessions, both sequential and concurrent, for efficient execution of mappings and used other tasks like event wait, event raise, email and command.
• Used Informatica for loading teh historical data from various tables for different departments.
• Developed Informatica mappings for Slowly Changing Dimensions Type 1 and 2.
• Created Mapplets for implementing teh incremental logic, in identifying teh fiscal quarter of teh transaction and in calculating various requirements of business processes.
• Involved in teh Unit & Integration testing of teh mappings and workflows developed for teh enhancements in teh application.
• Code migration of Informatica jobs from Development to Test to Production. Performed Unit testing, Integration Testing, Job & Environment Parameters Testing along teh way.
• Scheduled and ran Extraction and Load processes and monitored tasks and workflows.
• Tuned teh MMW databases (stage, target) for better, faster and efficient loading and user query performance,
• Created Informatica mappings wif PL/SQL stored procedures/functions to in corporate critical business functionality to load data,
• Extensively worked on performance tuning of mappings, sessions, Target, Source and various ETL processes.

Environment: Informatica 9.0.1, Oracle, DB2, NOSQL, Erwin, Oracle, SQL server, Shell scripting, TOAD.

Confidential

ETL Developer

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development, testing, and rollout to teh field user and support for production environment.
• Involved in Analysis of teh current system and Design solutions to create a centralized data warehouse as well as planning migration solutions from teh current system to teh new system.
• Used Informatica to extract data from different Source systems DB2 and Flat files tan into Oracle Target system.
• Designed and developed mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into teh data warehouse.
• Actively involved in teh scripting team for shell script to automate and migrate data from ODS to Data warehouse.
• Involved in different team review meetings.
• Involved in Development and Data Integration of teh main components using Informatica Power Center.
• Used different Transformations like Expression, Router, Filter, Sequence Generator, Stored Procedure, Connected and Un-connected Look ups etc.
• Created teh mapping and Functional Specifications.
• Managed software releases after each stage of teh testing and defect removal. As well as resolving issues from UAT and System testing.

Environment: Informatica Power Center 8.6, Oracle 9i, UNIX Flat files, SQL, PL/SQL and UC4 Scheduling tool.

Confidential

Informatica Developer

Responsibilities:

• Performed requirements gathering, developed Analysis & Design document (A&D), developed Project timeline.
• Designed and developed teh ETL Mappings for teh source systems data extractions, data transformations, data staging, movement and aggregation.
• Developed standard mappings using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter for weekly, quarterly process to loading heterogeneous data into teh data warehouse. Source files include delimited flat files, and SQL server tables.
• Extensively used Transformations like Router, Aggregator, Joiner, Expression, Lookup, Update strategy, Union, and Sequence generator.
• Executed sessions, both sequential and concurrent, for efficient execution of mappings and used other tasks like event wait, event raise, email and command.
• Used Informatica for loading teh historical data from various tables for different departments.
• Developed Informatica mappings for Slowly Changing Dimensions Type 1 and 2.
• Involved in teh Unit & Integration testing of teh mappings and workflows developed for teh enhancements in teh application.
• Code migration of Informatica jobs from Development to Test to Production. Performed Unit testing, Integration Testing, Job & Environment Parameters Testing along teh way.
• Scheduled and ran Extraction and Load processes and monitored tasks and workflows.
• Tuned teh databases (stage, target) for better, faster and efficient loading and user query performance,
• Created Informatica mappings wif PL/SQL stored procedures/functions to in corporate critical business functionality to load data,
• Extensively worked on performance tuning of mappings, sessions, Target, Source and various ETL processes.

Environment: Informatica 8.6, Oracle, SQL server, Shell scripting, Unix.