Candidates About

§  9 Years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration solutions using Informatica Power Center 9.5/9.x/ 8.x/ 7.x.

§  Proficiency in requirement gathering and data modeling including design and support of various applications in OLTP, Data Warehousing, OLAP and ETL Environment.

§  Experience in Talend Open Studio and Talend Integration Suite.

§  Experience working on Talend ETL and used features such as Context variables, Database components like tMSSQLInput, tOracleOutput, tmap, tFileCopy, tFileCompare, tFileexist file components and ETL components etc.

§  Extensive experience in developing complex mappings from varied transformations like Router, Filter, Sorter, Connected and Unconnected lookups, Normalizer, Expression, Aggregator, Joiner, Union, Update Strategy, Stored Procedure and Sequence Generator etc.

§  Good knowledge on Informatica IDQ & Informatica Power Exchange.

§  Experience with dimension modeling using Star and Snow flake schemas.

§  Expertise in design and implementation of Slowly Changing Dimensions (SCD) type1, type2, type3.

§  Experienced in loading data, troubleshooting, Debugging mappings, performance tuning of Informatica (Sources, Targets, Mappings and Sessions) and fine-tuned transformations to make them more efficient in terms of session performance.

§  Proficient in Relational Database Management Systems (RDBMS).

§  Expert in writing SQL queries and optimizing the queries in Oracle, SQL Server 2008, Netezza and Teradata. 

§  Experienced in other ETL tools like Abinitio, SSIS packages. 

§  Created SQL script to create/drop database objects viz: tables, views, indexes, constraints, sequences and synonyms.

§  Database experience using Oracle 11g/10g/9i, MS SQL Server 2000 and MS Access.

§  Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

§  Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.

§  Experience in ETL processes involving migrations and in sync processes between two databases.

§  Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2005/2008).

§  Experienced in loading and maintaining Data Warehouses in Teradata. Extensively used tools are MLoad, BTeq, FastExport and FastLoad to design and develop dataflow paths for loading transforming and maintaining data warehouse.

§  Expertise in working with various operational sources like Oracle, Teradata, DB2, SQL Server 2005/2008, Flat files, Netezza into a staging area. 

§  Expert in generating writing parameterized queries, drill through reports and formatted SQL server Reports in SSRS 2005/ 2008/2008 R2 using data from ETL Loads, SSAS Cubes and various heterogeneous data sources.

§  Expertise in using global variables, expressions and functions for the reports with immense experience in handling sub reports in SSRS.

§  Experienced in installing and configuring Reporting services and assigning permissions to different levels of users in SSRS.

§  Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS 2005/2008.

§  Experience in Informatica PowerCenter 9.5/9.x/8.x/7.1.4/6.2 with Oracle 9i/10g. 

§  Strong experience using SQL, PL/SQL Procedures/Functions, Triggers and Packages.

§  Experience in UNIX Operating System and Shell scripting.

§  Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, system integration and user acceptance testing.

§  Excellent skills in fine tuning the ETL mappings in Informatica.                        

§  Extensive experience using database tool such as SQL *Plus, SQL * Loader

§  Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team.

 

Technical Skills:

Operating Systems	Windows 2008/2007/2005/NT/XP, UNIX, MS-DOS
ETL Tools	Informatica Power Center 9.5/9.x/8.6/8.5/8.1/7.1 (Designer, Workflow Manager, Informatica IDQ, Informatica Power Exchange, Workflow Monitor, Repository manager and Informatica Server), Talend, SSIS, Ab-Initio.
Databases	Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005, DB2 v8.1, Teradata.
Data Modeling tools	Erwin, MS Visio
Languages	SQL,  PL/SQL,  UNIX, Shell scripts, C++, SOAP UI, JSP, Web Services, Java Script, HTML, Eclipse
Scheduling Tools	Autosys , Control-M, TWS
Testing Tools	QTP, WinRunner, LoadRunner, Quality Center, Test Director, Clear test, Clear case.

 

Professional Experience:

 

Anthem Healthcare, Norfolk, VA                                                                                                   Dec’14-Till Date

Sr. ETL Informatica Developer

 

Roles & Responsibilities:

§  Gathered user Requirements and designed Source to Target data load specifications based on Business rules.

§  Used Informatica PowerCenter9.5 for extraction, loading and transformation (ETL) of data in the data mart.

§  Designed and developed ETL Mappings to extract data from flat files, MS Excel and Oracle to load the data into the target database.

§  Developing several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using   Informatica PowerCenter.

§  Extensively used ETL processes to load data from various source systems such as SQL Server and Flat Files, XML files into target system applying business logic on transformation mapping for inserting and updating records when loaded.

§  Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 and SSIS in Business Intelligence Development Studio (BIDS).

§  Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.

§  Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008.

§  Prepared the complete data mapping for all the migrated jobs using SSIS.    

§  Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.

§  Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.

§  Developed PL/SQL triggers and master tables for automatic creation of primary keys.

§  Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.

§  Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator. Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.

§  Implemented Slow changing dimensions SCD-1 and SCD-II mappings to upgrade Slowly Changing Dimension Tables.

§  Experience in migration Informatica objects from 9.1 to 9.5.

§  Experience in Informatica upgrade testing, troubleshoot and resolve issues.

§  Created complex mappings in the designer and monitored them. The mappings involved extensive use of Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence generator transformations.

§  Ran the workflows on a daily and weekly basis using Tidal Scheduling tool.

§  Examined the workflow log files and assigning the ticket to the Informatica support based on the error.

§  Experience in developing Unix Shell Scripts for automation of ETL process.

§  Performed operational support and maintenance of ETL bug fixes and defects.

§  Maintained the target database in the production and testing environments.

§  Supported migration of ETL code from development to QA and QA to production environments.

§  Migration of code between the Environments and maintaining the code backups.

§  Designed and developed Unix Shell Scripts, FTP, sending files to source directory & managing session files

§  Done extensive testing and wrote queries in SQL to ensure the loading of the data.

§  Developed PL/SQL code at the database level for the new objects.

Environment: Informatica PowerCenter 9.5, PL/SQL, Flat files, Facets, XML, SQL Server 2012R2, SQL Integration Services(SSIS), Ab Initio, Microsoft Visual Studio 2010, SVN, Tidal, Microsoft Visio.

 

SAIC, McLean, VA                                                                                                                             Sept’13-Nov’14

Sr. ETL/Informatica Developer

 

Roles & Responsibilities:

§  Involved in gathering business requirements and attended technical review meetings to understand the data warehouse model.

§  Involved in data modeling and design of data warehouse in star schema methodology with confirmed granular dimensions and Fact tables.

§  Developed Technical Specifications of the ETL process flow

§  Extensively used ETL to load data from Flat files, SQL Server and Oracle into teradata.

§  Developed, deployed, and monitored SSIS Packages and Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.

§  Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.

§  Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005/2008.

§  Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server.

§  Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.

§  Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.

§  Used Informatica Designer to Extract & Transform the data from various source systems by incorporating various business rules. Also used different transformations, sessions and command tasks.

§  Created mappings using different transformations like Aggregator, Expression, Stored Procedure, Filter, Joiner, Lookup, Router and Update Strategy.

§  Developed PL/SQL triggers and master tables for automatic creation of primary keys.

§  Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.

§  Developed Advance PL/SQLpackages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQLNavigator. Generated server side PL/SQLscripts for data manipulation and validation and materialized views for remote instances.

§  Worked with Teradata data lake.

§  Responsible for design and developing Teradata BTEQ scripts, MLOAD based on the given business rules and design documents.

§  Experience in Coding Teradata SQL, Teradata Stored Procedures, Macros and Triggers

§  Loading the data into Netezza from legacy systems and flat files using complex UNIX scripts. Implemented Slow changing dimensions SCD-1 and SCD-II mappings to upgrade Slowly Changing Dimension Tables.

§  Experience in migration Informatica objects from 9.1 to 9.5.

§  Experience in Informatica upgrade testing, troubleshoot and resolve issues.

§  Created complex mappings in the designer and monitored them. The mappings involved extensive use of Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence generator transformations.

§  Ran the workflows on a daily and weekly basis using Active Batch Scheduling tool.

§  Examined the workflow log files and assigning the ticket to the Informatica support based on the error.

§  Experience in developing Unix Shell Scripts for automation of ETL process.

§  Performed operational support and maintenance of ETL bug fixes and defects.

§  Maintained the target database in the production and testing environments.

§  Supported migration of ETL code from development to QA and QA to production environments.

§  Designed and developed Unix Shell Scripts, FTP, sending files to source directory & managing session files

§  Done extensive testing and wrote queries in SQL to ensure the loading of the data.

§  Developed PL/SQL code at the database level for the new objects.

Environment: Informatica PowerCenter 9.5, Oracle11g/9i, PL/SQL, Flat files, Facets, XML, Teradata, SQL Server 2012R2, SQL Reporting Services (SSRS), SQL Integration Services (SSIS)

                                                                     

KROGER, Cincinnati, OH                                                                                                                    Apr’11-Sep’13

Sr. ETL Developer

 

Roles & Responsibilities:

§  Gathered user Requirements and designed Source to Target data load specifications based on Business rules.

§  Designed and Implemented the ETL Process using Informatica power center.

§  Involved in Data Extraction from Oracle, Flat files using Informatica.

§  Experience in analysis members and providers data.

§  Used Source Analyzer and Warehouse designer to import the source and target database schemas.

§  Create ETL Mapping with Talend Integration Suite to pull data from Source, apply transformations, and load data into target database.

§  Developed and designed ETL Jobs using Talend Integration Suite (TIS) in Talend 5.2.2.

§  Created complex jobs in Talend 5.2.2 using tMap, tJoin, tReplicate, tParallelize, tJava, tJavaFlex, tAggregateRow, tDie, tWarn, tLogCatcher, etc.

§  Used tStatsCatcher, tDie, tLogRow to create a generic joblet to store processing stats.

§  Created Talend jobs to populate the data into dimensions and fact tables.

§  Created Talend ETL job to receive attachment files from pop e-mail using tPop, tFileList, tFileInputMail and then loaded data from attachments into database and archived the files.

§  Used Talend joblet and various commonly used Talend transformations components like tMap, tDie, tConvertType, tFlowMeter, tLogCatcher, tRowGenerator, tSetGlobalVar, tHashInput & tHashOutput and many more.

§  Created mappings from source systems to target systems. Implemented Join, Expression, Aggregate, Sort, Rank, Lookup, UpdateStrategy, Filter and Router Transformations in Mappings.

§  Worked on Designer tool –Source Analyzer, warehouse designer, Mapping Designer and Mapplet Designer and Transformation Developer.

§  Involved in complete software development life cycle (SDLC) of the project.

§  Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.

§  Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).

§  Extracted data from Oracle and migrated into SQL Server 2008 using SSIS.

§  Created SSIS package to load data from Flat File (2GB -- 4GB) to Flat File and Flat File to SQL Server 2008 using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, Slowly Changing Dimension. 

§  Used custom .NET assemblies for Script Task in SSIS. 

§  Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.

§  Creating Reusable Transformations and Mapplets in a mapping.

§  Worked on moving mappings from Development to Test and from Test to Production environments.

§  Migrated Mappings, Sessions, and Workflows from Development to Test and then to Production environment.

Environment: Informatica PowerCenter 9.1, Talend 5.2, SQL Server 2008, SQL Server Integration Services (SSIS), Facets, Windows XP, Oracle 11g, VSS

 

MISO Energy, Carmel, IN                                                                                                                  Nov’09-Mar’11                                                 

ETL Informatica Developer

 

Roles & Responsibilities:

§  Interacted with Business Analysts to understand the requirements and the impact of the ETL on the business.

§  Worked with data modellers in preparing logical and physical data models and adding/deleting necessary fields using Erwin.

§  Extracted data from flat files and oracle database, applied business logic to load them in the central oracle database.

§  Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center.

§  Created reusable transformations and mapplets and used them in mappings.

§  Implemented slowly changing dimensions to maintain current information and history information in dimension tables.

§  Involved in creation of Folders, Users, Repositories, Deployment Group using Repository Manager.

§  Worked on different data sources such as Oracle, SQL Server, Flat files etc.

§  Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.

§  Created E-mail notifications tasks using post-session scripts.

§  Wrote SQL, PL/SQL stored procedures, triggers, cursors for implementing business rules and transformations.

§  Used Change Data Capture to implement incremental load.

§  Created various reports in report studio and packages in framework manager.

§  Generated various reports like List, Crosstab, Chart, Master detail, Drill through reports in report studio.

§  Provided support to develop the entire warehouse architecture and plan the ETL process.

Environment: Informatica PowerCenter 9.1/ 8.6.1, Oracle 11g/10g, SQLServer2008, PL/SQL, Erwin, XML, UNIX, UDB DB2 8.1, Autosys

 

BA Continuum, India                                                                                                                          July’08-Oct’09

Role: ETL Informatica Developer

 

Roles & Responsibilities:

§  Experience with ETL/ETI (Informatica) (Extraction Transform and Loading, Extraction Transform and Import) data from production database to data warehouse database.

§  Worked on transformations such as source qualifier, joiner, lookup, rank, expression, aggregator and sequence generator etc.

§  Reused mapping, mapplets and transformations.

§  Scheduled sessions and batches on the Informatica Server using Informatica Server.

§  Tuned transformations and mappings in Informatica.

§  Implemented slowly changing dimensions.

§  Created Unix Shell Scripts and PL/SQL procedures.