PROFESSIONAL SUMMARY:

• Over 7 years of experience as the ETL/Informatica developer.
• Good experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Insurance and Financial purpose.
• Experience in Business Intelligence solutions using Data Warehousing/Data mart design, ETL and reporting tools.
• Expertise in implementing complex business rules by creating robust Mappings, Mapplets, Sessions and Workflows using Informatica PowerCenter.
• Extensive experience in Extraction, Transformation, and Loading (ETL) data from various data sources into Data Warehouse and Data Marts using Informatica PowerCenter.
• Hands on Experience working with scheduling tools like Autosys, Control M, Maestro Cleansing tools. Worked on MSBI tools such as SSIS, SSRS etc for a brief period.
• Experience with Informatica Data Quality and Master Data Management products.
• Experience in working with relational databases such as Oracle, SQL Server, DB2, MS Access and Teradata.
• Designed parallel jobs using various stages like Join, Merge, look up, Filter, Remove Duplicates, Data Set, look up File Set, Complex Flat File, Modify, Aggregator, XML. Worked on file processing
• Good Experience in developing complex mapping using transformations like Source Qualifier, Router, Filter, Expression, Sorter, Aggregator, Normalizer, Joiner, Sequence Generator, Connected and Unconnected Lookup and Update Strategy, XML Source Qualifier.
• Experience in complete Software Development Life Cycle (SDLC) including Requirement, Analysis, estimations, Design, Construction, Unit and System Testing and implementation.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages, Cursors, Triggers, Views, and Indexes in distributed environment.
• Been part of various integration, reporting, migration, enhancement engagements.
• Experience in requirement gathering, planning, analysis, design, implementation, unit testing, code migration, production support with expertise in developing business applications much based on RDBMS.
• Proficient in the integration of CRM data source such as Sales force and good knowledge on insert update.
• Expertise in Database Design, Development of SQL, PL/SQL and Query tuning for better performance.
• Experience in the use of agile methodologies with SCRUM, Sprint.
• Strong understanding in UNIX Shell scripts and writing SQL Scripts for development, automation of ETL process, error handling, and auditing purposes.
• Worked with cross - functional teams such as QA, DBA and Environment teams to deploy code from development to QA and from QA to Production server.
• Involved in analyzing the source data coming from different Data sources such as XML, DB2, Oracle, flat files.
• Excellent analytical, problem solving skills with strong technical background and interpersonal skills

TECHNICAL SKILLS:

Data Warehousing: Informatica PowerCenter, B2B DX/DT, MDM, IBM Web Sphere Data Stage and Quality Stage.

Reporting Tools: Tableau, QlikView, SAP BO

Databases: Oracle, MySQL, MS SQL Server, Sales force, Teradata

Languages/Web: SQL, PL/SQL, HTML, Java, Shell Scripting and MS-Excel, XML, XSD, XSLT, HTML, Unix Shell Scripting.

GUI Tools: SQL*Loader, TOAD, Data Loader Tool

Modeling Tool: Erwin, Visio

Environment: MS Windows, Linux

WORK EXPERIENCE:

Confidential, RICHMOND, VA

ETL/ Informatica Developer

Responsibilities:

• Involved in gathering the requirements.
• Performed unit testing based on mapping specifications by writing queries in Toad and checked the fields to make sure the data has been properly populated from source to target
• Worked on Informatica B2B data transformation (DT) studio Performed B2B data exchange (DX) operation.
• Architecting the offload of ETL from Teradata to Hadoop on Azure with Enterprise and Solution architecture teams.
• Merged different source systems and transformed the data using B2B Data Transformation.
• Developed and executed the packages in the Toad while performing Unit testing.
• Designed ETL process using Informatica Tool to load from Sources to Targets through data Transformations.
• Involved in gathering business requirements, logical modeling, physical database design, data sourcing and data transformation, data loading, SQL, and performance tuning.
• Developed advanced Oracle stored procedures and handled SQL performance tuning.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Involved in designing logical and physical database designing using ERWIN tool.
• Developed Informatica cloud jobs which extract data from salesforce by calling webservices(REST) using start/endpoint URLs and writing the data to Flat files and updating back to salesforce based on business requirements.
• Involved in Informatica cloud administration activities such has configuring connectors, secure agents etc.
• Selected to represent the business intelligence and reporting teams as a member of a full-stack development team, part of an agile pilot program. Designed and implemented the infrastructure for OLTP system data migrations, which became the framework for future data migration projects.
• Worked with team of developers on Python applications for RISK management.
• Involved in creating the mapping documents with the transformation logic for implementing few enhancements to the existing system.
• Created mapping documents to outline data flow from sources to targets.
• Used Transformations like Filter, Router, Expression, Source Qualifier, Connected and Unconnected Look up to develop mappings in the DEV using Informatica PowerCenter Designer.
• Load and Extract from multiple cloud applications and Legacy applications.
• Used Informatica Designer to load the data from Flat files and from the Relational tables. Performed analysis of unstructured data using R language.
• Develop and Maintain processes that conduct service calls through APIs that interface with applications on cloud.
• Responsible for providing inputs to the Infrastructure Design document for multiple projects like system replat form and upgrades. With a wide-range of infrastructure knowledge, very much involve in the review process of the infrastructure design.
• Worked on source system such as Teradata, Oracle etc. Involved in writing Unix Shell script.
• Used JIRA tool to track defects and to develop unit test cases.
• Used WINSCP to import Parameter files, and flat files.
• Implementing the warehouse and providing solutions as per BRD (Business Requirement Document).
• Troubleshoot all errors related to the Oracle EPM Suite, both application and infrastructure side.
• Have written complex SQL queries in Toad by using inner, left outer and right outer joins.
• Expertise in SDLC & Agile Methodology including requirement gathering & analysis, designing, testing, integration, maintenance and support.
• Creating and monitoring cloud watch dashboard.
• Partnered with Engineering on POC's for Azure Cloud and Informatica Developer to test the implementation of the strategy decided on by architecture.

Environment: Informatica Power Center, MS SQL server, B2B DT, B2B DX, Oracle, Teradata, Toad, UNIX, Putty, WinSCP, Azure, JIRA.

Confidential, JERSY CITY, NJ

ETL/ Informatica Developer

Responsibilities:

• Analyzed the source data, Coordinated with Data Warehouse team in developing Relational Model and Participated in the Design team and user requirement gathering.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes.
• Tables, Views and other T-SQL code and SQL joins for applications. Developed various T-SQL. stored procedures, functions and packages, Built Data Transformation Services (DTS) packages for ETL using DTS wizard, Involved in Designing ER models (Logical/Physical) for Oracle database to store data retrieved from other sources including legacy systems.
• Extensively used Informatica PowerCenter to extract data from various sources and load into staging database.
• 24/7 (NOC) Network Operations Center, includes statistical reports and test result feedback to the engineers and other as required.
• Solved T-SQL performance issues using Query Analyzer. Parsed the data from XML’s XSD file using xml transformation. Participated in the detailed level and high-level design documentation of the ETL system and mapping of business rules.
• Interacted with business representatives for Need Analysis and to define Business and Functional Specifications. Retrieved data from MQ Series sources.
• Worked on golden copy of Master Data Management tool of Informatica (Informatica MDM).
• Expertise in the optimization of the performance of the Designed workflows processes in Informatica and to identify the bottlenecks in different areas after the full volume system run.
• Implemented Slowly Changing Dimension methodology for accessing the full history.
• Created Several Informatica Mappings to populate the data into dimensions and fact tables.
• Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and other database related issues.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.
• Developed Workflows and session to load data into targets.
• Working closely with developers on SCRUM team to transition ETL from Informatica PowerCenter to Informatica Developer on an Azure Cloud Platform for cost savings and performance gains.
• Used Informatica Power Exchange interface to get the data from mainframe files.
• Standardize and configure the mappings with data quality transformations to compare the values on a field-field basis by using IDQ Workbench.
• Used Standardize transformation to identify the customer information such as spelling in the columns, address, number format of SSN and telephone area code etc.
• Used Address Validator transformation to format the data by analyzing input/output ports.
• Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter Update Strategy, Joiner, Transaction Control and Stored Procedure.
• Scheduled sessions and work flows using Autosys / Informatica scheduler.
• Worked with pre-and post sessions and Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager.
• Participating in architecture design and implementation for Data Lake and Azure Cloud Migration
• Created and maintained cloud Database on AWS for testing applications.
• Tuned performance of Informatica session for large data files by increasing block size, data Cache size, sequence buffer length and target based commit interval. Worked on Informatica power center number.
• Developed the Test Scripts and performed the Unit Tests on the ETL mappings. Successful code migration from DEV to Testing & Production environment.
• Experienced in methodologies like SDLC and Agile methodologies such as SCRUM.

Environment: Informatica, Azure, Oracle, SQL server, DB2, UNIX, MS Excel, Teradata.

Confidential, Huntington, IN

ETL Developer

Responsibilities:

• Involved in performing a high-volume call assessment and developing migration strategies to include in project plans.
• Assisted with establishing and administering the Informatica environment.
• Designed and documented all the ETL Plans.
• Worked with Oracle, SQL Server and flat file sources.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Extracted Erwin physical models into repository manager using Informatica.
• Worked on Informatica MDM. Worked on sources such as Teradata, Oracle etc.
• Worked on Unix Shall script. Worked on Data profiling.
• Involved in writing conversion scripts using PL/SQL, stored procedures, functions, packages to migrate the data from SQL server database to Oracle database.
• Studied the existing OLTP systems and created facts, dimensions and star schema representation for the data mart using Erwin.
• Involved in writing Stored Procedures and calling them in Informatica Workflow Manager to drop the data from stage tables.
• Responsible for tuning the ETL mappings in order to gain high performance.
• Responsible for unit testing the developed mappings and involved in UAT sessions.
• Involved in migrating the plans from Development to Production and automating the process.

Environment: Informatica, Oracle, SQL server, PL/SQL, IBM AIX, UNIX, MS Excel, Erwin, Autosys, Teradata.

Confidential

ETL Developer

Responsibilities:

• Developed ETLs to load data from Microsoft SQL Server into target Oracle Database.
• Understanding the customer's requirements, analysis, design, development and implementation of system gather and define business requirements, improve business processes.
• Developed simple & complex mappings using Informatica to load dimension & fact tables as per STAR Schema techniques.
• Worked with Static, Dynamic and Persistent Cache in the Look up Transformation for the better throughput of Sessions.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Created Tables, Keys and Indexes in SQL Server.
• Developed DDL’s, DML’s, PL/SQL stored procedures, indexes for ETL operations on Oracle and SQL Server databases.
• Worked on source system such as oracle, Teradata etc.
• Worked on different tasks in the Informatica workflow manager like Session, Event raise, Event wait, Decision, E- Mail, Command, Assignment and Timer.
• Developed reusable Mapplets and Transformations.
• Created SQL, PL/SQL, scripts for data validation and reconciliation.
• Used Procedure Transformations to invoke Oracle PL/SQL Procedures.
• Used Informatica Version Control for checking in all versions of the objects used in creating the mappings, workflows to keep track of the changes in the development, test and production.
• Identified performance issues in the existing sources, targets and mappings by analyzing the data flow evaluating transformations and tuned accordingly for better performance.
• Involved in Informatica code deployments to all the environments.

Environment: Informatica, Oracle, SQL server, Web Services, MS Office, UNIX