SUMMARY

• Around 8 plus years of IT Experience in analysis, design, development, implementation, and troubleshooting of Data warehouse applications.
• Demonstrated expertise in utilizing ETL tool Informatica PowerCenter 10.2./9.6, Informatica Power Exchange10.2/9.6 and administrating the Data warehouse loads as per client requirement.
• Experience working with data lake implementation. Involved in development using Informatica to load data into Hive and impala systems.
• 3 years of working knowledge of Informatica CDC, ESB/Cloud integrations
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Built Data pipelines by creating Cloud ETL mappings in Informatica Intelligent Cloud Service and published them to be used in API calls.
• Utilized Power Query in Power BI to Pivot and Un - pivot the data model for data cleansing and data massaging.
• Excellent knowledge in identifying performance bottlenecks and tuning the Informatica Load for better performance and efficiency.
• Expertise in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts, Data Lake and Decision Support Systems (DSS) using Multidimensional and Dimensional modeling (Star and Snowflake schema) Concepts.
• Strong understanding of Data warehouse project development life cycle. Expertise in documenting all the phases of DWH projects.
• Worked with Informatica Data Quality (IDQ) for cleansing and applied business rules.
• Extensive knowledge in developing Teradata, Fast Export, Fast Load, Multi load and BTEQ scripts. Coded complex scripts and finely tuned the queries to enhance performance.
• Experience in writing b procedures for processing business logic in the database. Tuning of SQL queries for better performance.
• Experienced in massive data profiling using IDQ (Analyst tool) prior to data staging
• Design reference data and data quality rules using IDQ and involved in cleaning the data using IDQ in Informatica Data Quality 10.2/9.6 environment.
• Designed Data Quality using IDQ and developed several informatica mappings.
• Involved in all phases of data warehouse project life cycle.
• Designed and developed ETL to load data from various sources like DB2 UDB, Oracle, Flat files, XML files, Sybase and MS SQL Server into Oracle, Teradata, XML, SQL Server, Hive, Impala and Azure targets.
• Significant Multi-dimensional and Relational data modeling experience, Data Flow Diagrams, Process Models, ER diagrams with modeling tools like ERWIN & VISIO.
• Experience with Informatica Deployments using deployment groups and third-party deployment tools.
• Good understanding on Hive SQL.
• Good experience in designing and developing audit, error identification and reconcile process to ensure the Data Quality of Data warehouse.
• Strong experience in implementing CDC using Informatica PowerExchange 10.2/9.6. Creating registration groups and extraction groups for CDC implementation.
• Profound knowledge about the architecture of the Teradata database.
• Extensive experience in implementation of Data Cleanup procedures, transformations Scripts, Triggers, Stored Procedures and execution of test plans for loading the data successfully into the targets.
• Extensive experience in developing mappings using various transformations like Source Qualifier, Expression, Lookup, Aggregator, Router, Rank, Filter and Sequence Generator transformations and various reusable components like Mapplets and reusable transformations.
• Extensive experience is maintaining Informatica connections in all the environments like Relational, Application and FTP connections.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter (10.2/9.6.1), Informatica PowerExchange (10.2.1/9.6.1 ), (SQL Server 2014, 2012), IICS R29, IDQ

Database: Oracle 12c/11g/10g, MS SQL Server (2016,2014,2012), PostgreSQL, Teradata 14S/13, DB2-UDB, Netezza

BI/Reporting Tools: Tableau, OBIEE, Pentaho, Business Objects, Crystal Report, Micro Strategy

Data Modeling Tools: ER/Studio, ERWIN, Power Designer

Languages: SQL, PL/SQL, T-SQL, UNIX Shell Scripts, Java, VB Scripts

Operating Systems: UNIX/LINUX, AIX, Windows, MS Windows Server, MS DOS

Other Applications: Toad, SQL Developer, Visual Studio, MS Visio, Control M, Autosys, JIRA, QC

Protocol: ODBC, JDBC, OLE DB, TCP/IP

Server: MS SQL Server, LINUX Server

PROFESSIONAL EXPERIENCE

Confidential, Raleigh, NC

Sr. ETL Informatica Developer

Responsibilities:

• Used Informatica PowerCenter for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• By mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Installed and upgraded the databases such as Oracle, SQL, PostgreSQL and MySQL in Windows and Linux Servers.
• Extensive experience in integration of Informatica Data Quality (IDQ) with Informatica PowerCenter.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
• Effectively using IICS Data integration console to create mapping templates to bring data into staging layer from different source systems like Sql Server, Oracle, Teradata, Salesforce, Flat Files, Excel Files, PWX CDC.
• Worked on a POC to integrate Amazon S3 bucket with Informatica Intelligent Cloud Services (IICS) for processing multiple files parallel.
• Extensively worked inOracle SQL, PL/SQL, SQL Plus, Query performance tuning, Created DDL scripts and Database objects like Tables, Views and Indexes
• Introduced GitHub as a version control plugin for IICS.
• Involved in performance optimization of IICS jobs and design efficient queries to query data from azure cloud database.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Data integration, warehouse and Migration using Informatica Cloud, Power Center & SFDC.
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
• Developed several reusable transformations and Mapplets that were used in other mappings.
• Prepared Technical Design documents and Test cases.
• Implemented various Performance Tuning techniques.
• Worked on IDQ file configuration at user’s machines and resolved the issues.
• Used IDQ to complete initial data profiling and removing duplicate data
• Used SQL tools like TOAD to run SQL queries to view and validate the data loaded into the warehouse.
• Performed data integration and lead generation from Informatica cloud into Salesforce cloud.
• Design reference data and data quality rules using IDQ and involved in cleaning the data using IDQ in Informatica Data Quality 9.1 environment
• Created summarized tables, control tables, staging tables to improve the system performance and as a source for immediate recovery of Teradata database
• Experience in Oversaw deployment, configuration and documentation procedures of Salesforce data integration using informatica cloud and power center
• Experience in informatica integration cloud service to integrate on prem database with Salesforce cloud system
• Created Stored Procedures to transform the Data and worked extensively in T-SQL, PL/SQL for various needs of the transformations while loading the data into Data warehouse.
• Developed transformation logic as per the requirement, created mappings and loaded data into respective targets.
• Worded on profiling source data and determining all source data possible values and metadata characteristics.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Wrote BTEQ scripts and also Teradata utilizes like FASTLOAD, MLOAD, and FASTEXPORT.
• Extensively worked on Unit testing for the Informatica code using SQL Queries and Debugger.
• Used PMCMD command to run workflows from command line interface.
• Improved performance testing in Mapping and the session level.
• Worked with UNIX shell scripts extensively for job execution and automation.
• Coordinated with Autosys team to run Informatica jobs for loading historical data in production.
• Documented Data Mappings/ Transformations as per the business requirement.
• Migration of code from development to Test and upon validation to Pre-Production and Production environments.
• Provided technical assistance to business program users and developed programs for business and technical applications.
• Responsible for team members’ work assignment and tracking.
• Written documentation to describe development, logic, testing, changes and corrections.

Environment: InformaticaPowerCenter 10.2, Informatica Data Quality 10.2, Autosys, SQL 9.4. IICS R29, CDC, Oracle 12c, DB2, SQL Server 2014, Hive, Impala, Teradata v15, Toad, Netezza, Unix.

Confidential, Tampa, FL

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.
• Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement.
• Developed mapping to load Fact and Dimension tables, for type 1 and type 2 dimensions and incremental loading and unit tested the mappings.
• Extracted data from a web service source, transform data using a web service, and load data into a web service target.
• Coordinate and develop all documents related to ETL design and development.
• Involved in designing the Data Mart models with Erwin using Star schema methodology.
• Used repository manager to create repository, user’s groups and managed users by setting up privileges and profile.
• 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.
• Used IDQ to profile the project source data, define or confirm the definition of the metadata, cleanse and accuracy check the project data, check for duplicate or redundant records, and provide information on how to proceed with ETL processes.
• Developed the audit activity for all the Informatica IICS (cloud) mappings.
• Automated/Scheduled the Informatica IICS (cloud) jobs to run daily with email notifications for any failures
• Involved in writing BTEQ, MLOAD and TPUMP scripts to load the data into Teradata tables.
• 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.
• Used IDQ’s standardized plans for addresses and names clean ups.
• Worked on IDQ file configuration at user’s machines and resolved the issues.
• Used IDQ to complete initial data profiling and removing duplicate data
• Executed sessions, sequential and concurrent batches for proper execution of mappings and set up email delivery after execution.
• Preparing Functional Specifications, System Architecture/Design, Implementation Strategy, Test Plan & Test Cases.
• Implemented and documented all the best practices used for the data warehouse.
• Improving the performance of the ETL by indexing and caching.
• 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.
• Code walks through with team members.
• Created UNIX shell scripting for automation of ETL processes.
• Used UNIX for check in’s and checks outs of workflows and config files in to the ClearCase.
• Experience in monitoring and reporting issues for the Daily, weekly and Monthly processes. Also, work on resolving issues on priority basis and report it to management.

Environment: Informatica PowerCenter 10.1, Informatica PowerExchange 10.1, Informatica Data Quality 9.5, Informatica Intelligent Cloud Services (IICS), Oracle 11g, SQL, PL/SQL, DB2 8.0, MS SQL Server 2008, T-SQL, Flat Files, Teradata 14, Windows XP, UNIX, SAP BODS, PL/SQL

Confidential, NY

Informatica Developer

Responsibilities:

• Worked with the business team to gather requirements for projects and created strategies to handle the requirements.
• Worked on project documentation which included the Functional, Technical and ETL Specification documents.
• Experienced in using Informatica for data profiling and data cleansing, applying rules and develop mappings to move data from source to target systems
• Designed and implemented ETL mappings and processes as per the company standards, using Informatica PowerCenter.
• Extensively worked on complex mappings which involved slowly changing dimensions.
• Developed several complex mappings in Informatica a variety of PowerCenter transformations, Mapping
• Parameters, Mapping Variables, Mapplets& Parameter files in Mapping Designer using both the Informatica PowerCenter and IDQ.
• Worked extensively on Informatica transformations like Source Qualifier, Expression, Filter, Router, Aggregator, Lookup, Update strategy, Sequence generator and Joiners.
• Debugged mappings by creating a logic that assigns a severity level to each error, and sent the error rows to error table so that they can be corrected and re-loaded into a target system.
• Deployed reusable transformation objects such as Mapplets to avoid duplication of metadata, reducing the development time.
• Worked on developing Change Data Capture (CDC) mechanism using Informatica PowerExchange or some of the interfaces based on the requirements and limitations of the Project.
• Implemented performance and query tuning on all the objects of Informatica using SQL Developer.
• Worked in the ETL Code Migration Process from DEV to ITE, QA and to PRODUCTION.
• Created the design and technical specifications for the ETL process of the project.
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups Using Connected, Unconnected, Expression, Aggregator, Update strategy & stored procedure transformation.
• Worked with SQL*Loader to load data from flat files obtained from various facilities.
• Worked on loading of data from several flat files to Staging using Teradata MLOAD, FLOAD and BTEQ.
• Worked with the Release Management Team for the approvals of the Change requests, Incidents using BMC Remedy Incident tool.
• Worked with the infrastructure team to make sure that the deployment is up-to-date.
• Provided 24x7 production support when necessary.

Environment: Informatica PowerCenter 9.6.1, PowerExchange 9.6.1, Informatica Data Quality 9.6, Erwin r7, Oracle 10g, SQL, PL/SQL, DB2 8.0, MS SQL Server 2008, Flat Files, Autosys, Windows XP, UNIX, PL/SQL, SQL*Loader, TOAD, ANSI SQL

Confidential

ETL Developer/ Data Analyst

Responsibilities:

• Involved in full life cycle development including Design, ETL strategy, troubleshooting Reporting, and Identifying facts and dimensions.
• Reviewing the requirements with business, doing regular follow ups and obtaining sign offs.
• Designed and developed mappings, Mapplets and sessions from source to target database using Informatica PowerCenter.
• Worked with various file formats like fixed length and delimited.
• Used Debugger extensively to validate the mappings and gain troubleshooting information about data and error conditions.
• Developed various mappings using Mapping Designer and worked with Source qualifier, aggregator, connected unconnected lookups, Filter transformation, and sequence generator transformations.
• Extensively used Informatica to transfer data from different source system and load the data into the target database.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Developed number of complex Informatica mappings, Mapplets and reusable transformations to implement the business logic and load the data incrementally.
• Used Debugger to track the path of the source data and to check the errors in mapping.
• Handled slowly changing dimensions of Type 1 and Type 2 to populate current and historical data to dimensions and fact tables in the Data warehouse.
• Developed Informatica mappings by usage of aggregator, SQL overrides in lookups, source filter and source qualifier and data flow management into multiple targets using router transformations.
• Implemented the best practices for the creation of mappings, sessions and workflows and performance optimization.
• Created Informatica Technical and mapping specification documents according to Business standards.
• Extensively involved in performance tuning of the ETL process by determining the bottlenecks at various points like targets, sources, mappings, sessions or systems.
• This led to a better session performance.
• Document the process for further maintenance and support. Worked on test cases and use cases.

Environment: Informatica PowerCenter 9.1, Oracle 10g, SQL Server, OBIEE, Teradata 13, Sybase, Windows XP, Visio 2000, Business objects XIR2, ESP, SCM, Putty, Win Scm, UNIX Windows.NET/98