PROFESSIONAL SUMMARY:

• 10+ years of IT experience in Analysis, Design, Development, Implementation, Testing and Supportof Data Warehousing and Data Integration Solutions using Informatica Powercenter, Datastage and SSIS
• 7+ years of experience in using Informatica Powercenter (9x/8x)
• Proficiency in developing SQL with various relational databases like Oracle, SQL Server,DB2,Teradata
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Extensively worked with Informatica performance tuning involving source level, Confidential level and map level bottlenecks.
• Strong business understanding of verticals like Banking, Insurance and retail
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Experience in resolving on - going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Teradata, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Experience in using Automation Scheduling tools like Autosys and Control-M.
• Worked extensively with slowly changing dimensions.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS:

Operating Systems: Windows 2008/2007/2005/ NT/XP, UNIX, MS-DOS

Tools: Informatica Power Center 9X/8X, Power Exchange,SSIS

BI Tool: SAP BO

Databases: Oracle 11g/10g/9i, MS SQL Server 2014/2016, DB2 11.1, Teradata

Languages: SQL, PL/SQL, UNIX, Shell scripts

Scheduling Tools: Autosys, Control-M

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio,TX

Senior ETL developer

Responsibilities:

• Played the role of a Program Technical Lead and was responsible for designing the ETL Strategy
• Was responsible in managing tasks and deadlines for the ETL teams both Onsite and Offshore.
• Was the point person on the ETL team for other teams such as Reporting, Testing, QA and Project Management for updates on Project Status and issues.
• Interaction with business users and requirement gathering.
• High level & low-level ETL flow design
• Give functional KT to the QA team.
• Responsible for ETL technical design discussions and prepared ETL high level technical design document.
• Translated the business requirements into Informatica mappings to build data warehouse by using Informatica designer, which populated the data into the Confidential .
• Organize daily technical discussions with the Onsite team also including the individual offshore workstream leads and set expectations for Offshore delivery.
• Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse.
• Maintained source and Confidential mappings, transformation logic and processes to reflect the changing business environment over time.
• Extensively used the Add Currently Processed Flat File Name port to load the flat file name
• Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Confidential .
• Extensively used workflow variables, mapping parameters and mapping variables.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Implemented Informatica recommendations, methodologies and best practices.
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Involved in Unit, Integration, System, and Performance testing levels.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Migrated the code into QA (Testing) and supported QA team and UAT (User).
• Created detailed Unit Test Document with all possible Test cases/Scripts.
• Involved in production support.

Confidential, Indianapolis, IN

Senior ETL developer Lead

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Lead an offshore team of three members. Ensure deliverable are prepared to satisfy the project requirements and schedule.
• Provide status reporting of team activities against the plan or schedule, inform task accomplishment, issues and status.
• Providing technical and functional knowledge to team members from Onsite.
• Reviewed the New/changed component coded by offshore team
• Establish meeting times, places and agendas, Ensure discussions and decisions lead to closure.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Develop the mappings using needed Transformations in Informatica tool according to technical specifications
• Created complex mappings that involved implementation of Business Logic to load data in to staging area.
• Refreshed the data by using fastexport and fastload utilities.
• Creating and modifying MULTI LOADS for Informatica using UNIX and Loading data into IDW.
• Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.
• Used Informatica reusability at various levels of development.
• Developed mappings/sessions using Informatica Power Center 9.5 for data loading.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Extracted data from Oracle and SQL Server then used Teradata for data warehousing.
• Pre and post session assignment variables were used to pass the variable values from one session to other.
• Implementedslowly changing dimensionmethodology for accessing the full history of accounts.
• Write Shell script running workflows in unix environment.
• Optimizing performance tuning at source, Confidential, mapping and session level
• Effectively worked on Onsite and Offshore work model.
• Participated inweeklystatus meetings, and conducting internal andexternal reviews as well as formal walk through among various teams and documenting the proceedings.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Confidential, Denver, CO

ETL Developer

Responsibilities:

• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into Confidential database.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• 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.
• 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.
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
• Imported various heterogeneous files using Informatica Power Center 8.x Source Analyzer.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Prepared Technical Design documents and Test cases.
• Involved in Unit Testing and Resolution of various Bottlenecks came across.
• Implemented various Performance Tuning techniques.
• Used Teradata as a source system

Confidential

ETL Tester

Responsibilities:

• Ensuring testing for the release is completed within testing window.
• Participating in Internal Reviews and raising QA logs.
• Running the jobs for ETL Process through Data stage 8.5 and Ctrl - M.
• Preparing and Executing SQL Queries.
• Analyzing the Data Mapping and identifying gaps/ambiguities
• Preparing Test Data.
• Data Mapping, Defect Analyzing and Reporting in Quality Centre
• Performing Functional Testing, Integration Testing, Regression Testing.
• Defect Tracking and Reporting, Defects Report generation and Consistent on-time delivery.
• Prepare lessons learnt document once the release is completed.
• Co-coordinating with client for completion of User Acceptance Testing & results verification
• Actively involved with the Client and On-shore team on the day to day basis regarding the project details.
• Participated in the review meeting with Customers, Leads, Developers and Management.

Confidential

ETL Developer

Responsibilities:

• Developed Informatica Mappings to load data from different Source systems to staging area.
• Developed Slowly Changing Dimensions mapping for Type1 SCD and Type2 SCD.
• Worked extensively with flat files and relational tables.
• Involving in the preparing of technical detail design documents.
• Coordinated with the Requirements gathering team to design Informatica jobs.
• Used various transformations like Source Qualifier, Joiner, Lookup, sql, router, Filter, Expression and Update Strategy.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools
• Documented Informatica mappings in Excel spread sheet.
• Tuned the Informatica mappings for optimal load performance.
• Load balancing of ETL processes, database performance tuning and capacity Monitoring
• Created unit test cases for the purpose of unit testing of various mappings
• Prepared Unit Test plan and efficient unit test documentation was created along with Unit test cases for the developed code.
• Developed Informatica mappings and also tuned for better performance.
• Worked with many existing Informatica mappings to produce correct output.

Confidential

ETL Developer & Support

Responsibilities:

• Extensively used ETL to load data from Flat Files, XML, Oracle to oracle 8i
• Involved in Designing of Data Modeling for the Data warehouse
• Involved in Requirement Gathering and Business Analysis
• Developed data Mappings between source systems and warehouse components using Mapping Designer
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator, joiner, XML.
• Setup folders, groups, users, and permissions and performed Repository administration using Repository Manager.
• Used various transformations like Source Qualifier, Joiner, Lookup, sql, router, Filter, Expression and Update Strategy.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools
• Documented Informatica mappings in Excel spread sheet.
• Tuned the Informatica mappings for optimal load performance.
• Involved in the performance tuning of the Informatica mappings and stored procedures and the sequel queries inside the source qualifier.
• Created, launched & scheduled sessions.
• Involved in the Performance Tuning of Database and Informatica. Improved performance by identifying and rectifying the performance bottle necks.
• Used Server Manager to schedule sessions and batches.
• Involved in creating Business Objects Universe and appropriate reports
• Wrote PL/SQL Packages and Stored procedures to implement business rules and validations.