PROFESSIONAL SUMMARY:

• Overall 7+ years of IT experience in analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehousing/Data mart design, ETL, OLAP client /server applications.
• Experience in data mart life cycle development, performed ETL procedure to load data from different sources into Data marts, Data warehouse and DSS using Informatica Power Center 9.5/9X - Designer, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager and Workflow Monitor.
• Experience with Relational and Dimensional Modeling using Star and Snow flake models for Data warehousing application.
• Experience in Automation & scheduling of processes, and Informatica sessions using Informatica Scheduler.
• Expertise in using Teradata Utilities like FastLoad, Multiload, Fast Export in conjunction with Informatica Power Center
• Worked on data quality tools, Informatica data quality (IDQ) 9.1 by creating mappings using different transformations available.
• Extensive working experience with Power center components of Informatica server and client tools like designer, workflow manager, repository manager and workflow monitor.
• 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.
• Expertise using MS SQL Server 2008/2005/2000 , oracle 11g/10g, DB 2 9.0/8.0/7.0 , Teradata 12
• Experience with dimensional modeling using star schema and snowflake models.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Vast experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Proficient in all phases of the Software development lifecycle, including requirements definition, Analysis, Design, System Implementation, Performance Tuning, Testing and Support.
• Proficiency in gathering business requirements, establishing functional specifications and translating them to design specifications.
• Proficient in transforming data from various sources (Teradata, Big Data, Greenplum, Oracle, DB2, Sybase, Flat files, XML files and SQL Server) to Data warehouse using ETL tools
• Experience with development and maintenance of Informatica mappings, workflows and other tasks, experience in creating reusable objects.
• Experience in integration mappings including dynamic cache lookup, shared, and persistent mappings for Type I, Type II, Type III slowly changing dimensions.
• Have worked with various databases like Teradata, Oracle 11g/10g, SQL Server 2005/2008/2012 and DB2/UDB.
• Experience in using SQL, PL/SQL, TOAD and SQL Developer.
• Proficient in using Teradata BTEQ Scripts in conjunction with SSIS Packages

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.5/9.1/8.6/8.1

Reporting Tools: Business Objects, Oracle Business Intelligence, Crystal Reports

Data Modeling: Erwin 7.2/4.0/3.5

Databases: Oracle 11g/10g, Netezza

Languages: SQL, PL/SQLTools

Operating Systems: SQL plus, TOAD, AutoSys UNIX, Windows 7

PROFESSIONAL EXPERIENCE:

Confidential, Dublin, OH

Senior ETL Developer

Responsibilities:

• Worked with the existing subject areas, source systems, target system, jobs and deployment processes with minimal supervision.
• Involved in implementing the Land Process of loading the customer/product Data Set into MDM Hub from various source systems.
• Use Teradata FastLoad and Multiload utilities in conjunction with Informatica Power Center
• Work on any or all iterations for one or more subject areas within the data warehouse
• Worked on data cleansing and standardization using the cleanse functions in Informatica.
• Used Hierarchy tools for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used the entity types as subject areas.
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.
• Informatica Data Quality (IDQ) is the tool used here for data quality measurement.
• Worked with Oracle and SQL Stored Procedures, Table Partitions, triggers, SQL queries, and PL/SQL packages to load data into Data Warehouse / Data Marts using Informatica, Import Utilities and SQL Loader.
• Extracted data from Oracle and SQL Server then used Teradata for data warehousing.
• Worked with DA’s, application teams, and gathered requirements.
• Extensively worked on Power connect, Power Exchange and Power Center to pull data from different sources like Oracle, SQL Server and SAP sources.
• Responsible for data security - Implementation of corporate policies and end user training.
• Designed ETL packages to load the data from staging server to Data marts on Data warehouse.
• Improved performance of various slow mappings, especially for historical load related jobs.
• Wrote reports using Tableau Desktop to extract data for analysis using filters based on the business use case.
• Used Informatica Power Center to extract, transform and load data from heterogeneous systems (Mainframe systems, flat files, Oracle) to Staging and Data warehouse (DWH).
• Created complex mappings with transformation objects such as Joins, Expressions, Filters, Union, Aggregator, Sequence, etc., to implement complex logic. These are used to cleanse data identified in the data quality analysis process and to re-structure the data for reporting purposes
• Scheduling the Informatica Cloud Service jobs using Informatica Cloud task scheduler.
• Developed mappings to extract data from SQL Server, Oracle, Flat files and load into Teradata, Oracle using the Power Center.
• Populating FastLoad and Multiload tables using different data load and unload utilities of Teradata
• Designed and developed the ETL process to load and extract data using Db2 Load and Oracle SQL loader.
• Responsible for designing and managing project specific ETL codes using SSIS and SQL Server fetching data across various source systems into Client specific Enterprise Data Warehouse.

Environment: Informatica Power Center 9.x/8.x, Informatica MDM Multi-Domain, DB2, Oracle, AutoSys, HP Quality Center, UNIX Shell Scripting, WINDOWS XP, Microsoft Visio, TOAD, Data Validation Option, CA - Harvest

Confidential, New York, NY

Senior ETL Developer

Responsibilities:

• Responsible for gathering and understanding the requirements from the business users and created business requirements document and functional specifications document.
• Developed detailed ETL technical specifications/design documents based on business requirements.
• Loaded fact and dimension tables as part of modified data warehouse solution.
• Designed and developed Informatica work flows, mappings for data loads, making use of different transformations, lookups, performance tuning and other ETL techniques.
• Created reusable Mapplet and Transformations to reduce the complexity in mappings and to handle repetitive tasks such as implementing data quality rules and getting Dimension details.
• Worked with multiple transformations like XML Parser, Filter, aggregator, update strategy, lookup, router, sequence generator and joiner using Informatica Power Center.
• Modify the existing Informatica objects which populate the data in staging environment and from staging to Teradata Data Warehouse
• Designed and developed ETL code using Ab Initio and Informatica as the ETL tool.
• Designed and developed the application using various transformation logics based on the business rules defined.
• Performed data quality analysis, gathered information to determine data sources, data targets, data definitions, data relationships, and documented business rules.
• Worked with business analysts to identify appropriate sources for data warehouse and prepared the Business Release Documents, documented business rules, functional and technical designs, test cases and user guides.
• Monitor the Data Quality, Generate weekly/monthly/yearly statistics/reports on production processes
• Coding using BTEQ SQL of Teradata, wrote UNIX scripts to validate, format and execute the SQL's on UNIX environment.
• Created mapping documents to outline data flow from sources to targets. Parsed high-level design specification to simple ETL coding and mapping standards.
• Involved in performance tuning of the Informatica Power Center Mappings/Sessions.
• Contribute to the design and development of the data warehouse system and assist with up to date documentation.
• Created ETL reusable processes for Error handling & Audit tracking.
• Designed and developed metadata driven solutions for data manipulation techniques using Ab Initio.
• Upgraded Informatica Power Center software from version 8.1 to 8.6. Trained new developers on Informatica basics
• Teradata SP/View/BTEQ development and involving in the code review meetings.
• Developed the automated scripts to execute the ETL graphs developed.
• Created and scheduled the automated ETL jobs using the AutoSys job scheduling tool.
• Created the system and integration test plans are developed and executed.
• Developed and tested the ETL application following all ETL standards and architecture.
• Analyzed, identified the root cause of defects encountered during the lifecycle of the project by writing SQL queries and using debugging techniques and resolved them.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to generating reports to business users.
• Created implementation plan for deploying the application into production environment.
• Created production support guide for different applications to resolve commonly encountered issues in the production environment.
• Performed in a leadership role on the project with design and development focus.

Environment: Informatica 10.1.1, Ab Initio (GDE 3.1.7, Co>Operating System 2.15), Netezza, Oracle 12c, 11g, UNIX, Rational Clear Quest, IBM Requisite Pro, HP Quality Center, Toad, PL/SQL, AutoSys.

Confidential, Dayton, OH

Senior ETL Developer

Responsibilities:

• Analyzed specifications and identified source data needs to be moved to Data Mart, participated in the design team and user requirement gathering meetings.
• Extensively used ETL (Informatica) to extract data from source Oracle DB to target Oracle database using Lookup, Aggregator, sequence, joiner and other transformations are used in populating data process.
• Created Informatica Mappings with PL/SQL procedures/functions to build business rules to load data.
• Developed ETL mappings, Transformations and Loading using Informatica Power Center 8.1.1.
• Extracted data from multiple sources through Informatica to Oracle to Teradata DWH.
• Involve in code Migration process to UAT environment.
• Operation of data warehouse and business intelligence support
• Attend the Program Level meetings to update weekly status on QA progress.
• Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Created mappings in Informatica Developer (IDQ) using Parser, Standardizer and Labeler, Exception, Merge Transformations.
• Exported Mappings from IDQ to Informatica Power Center.
• Worked on exporting data to flat files using Teradata FastExport.
• Extracted/loaded data from/into diverse source/target systems like Oracle, XML and Flat Files.
• Worked with Informatica Data Quality 9.x(IDQ) toolkit, analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ
• Modify the existing Informatica objects which populate the data in staging environment and from staging to Teradata Data Warehouse
• Created stored procedure and function to improve the Job performance.
• Created complex mappings which involved Slowly Changing Dimensions, implementation of business logic and capturing the deleted records in the source systems.
• Defined and documented the technical specification designs of all programming applications.
• Responsible for developing data extracts and transformation programs
• Extensively used UNIX shell scripting, general file manipulations etc.
• Supported System testing, UAT testing, and production go-live Support.

Environment: Informatica Power Center 8.x, Data quality, Oracle 8i, PL/SQL, XML, SQL, Tivoli, Windows NT, UNIX.

Confidential, Grand Rapids, MI

Senior ETL Developer

Responsibilities:

• Part of Scrum team where we were assigned multiple tickets (tasks) pertaining to ETL and ELT developments.
• Migrated big batch of legacy data to new the new Data Warehouse which was part of Big Data Project.
• Worked on Big Data project in Hadoop environment used to extract data from Hive into ETL.
• Built multiple queries and complex SQL's on Netezza environment.
• Unit Testing, Database testing, Data verification and validation of the code developed and compare the results with Oracle and Teradata systems.
• Creation of ETL and ELT code in Informatica to manage data integration tasks within the project team.
• Task included but not limited to, from simple file imports onto database to complex mapping involving integration of multiple systems within the company.
• Created AutoSys scripts to run ETL Informatica and other shell jobs.
• Codes, tests, debug documents and implements moderately complex software applications according to standards.
• Imported data from various Sources transformed and loaded into Data Warehouse Targets using Informatica Power Center.
• Created tables, views in Teradata, according to the requirements.
• Develops specifications and programs moderately complex technical modules, applications, prototypes and computer programs.
• Performs all aspects of applications programming and development and including file design, update, storage and retrieval.
• Involved in writing stored procedures and shell scripts for automating the execution of jobs.
• Evaluates and provides technical solutions to moderately complex application development problems.
• Monitor the Informatica jobs using CA Automation workstation(ESP)
• Developed mappings to extract data from SQL Server, Oracle, Flat files and load into Netezza, Oracle using the Power Center.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Assist in the continuing evolution of solutions ensuring we are on the vanguard of technologies.

Environment: Netezza, Informatica 9.6.1. AutoSys. Data quality, Agility. Archipelago testing tool.Hadoop, Hive, MDM

Confidential, Plano, TX

ETL developer

Responsibilities:

• Involved in the Design, Development, testing phases of data warehouse.
• Coordinate with application team and develop at ETL processes.
• Provide an efficient interface with brand for all processes across various platforms.
• Developed and tested Stored Procedures, Functions and packages in PL/SQL.
• Wrote functional documentation (use cases, interfaces, functionalities, data models).
• Worked on Informatica debugging using expression evaluator.
• Developed various transformations in Informatica and supported Data warehouse design and development extensively.
• This actual load process contains mostly Teradata stored procedures and is scheduled to run every day through 3rd party scheduling tool.
• Ensure data integration/ ETL is implemented & monitored successfully to enable data quality, availability, and data freshness.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Involved in writing stored procedures and shell scripts for automating the execution of jobs.
• Prepared the error handling document to maintain the error handling process.
• Automated the Informatica jobs using UNIX shell scripting.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Developed mappings to extract data from SQL Server, Oracle, Flat files and load into Teradata, Oracle using the Power Center.
• Implement and Enhance ETL programs using Informatica Power Center against the Oracle 11g Data Warehouse
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Design all test cases to provide support to all systems and perform unit tests.

Environment: Informatica 8.6, Java, Oracle9i, SQL, PL/SQL, Windows XP, MS-Access