PROFESSIONAL SUMMARY:

• 8 Years of total experience in Developing, Implementation of Extraction, Transformation & Loading (ETL) Life Cycle using Informatica Power Center and ETL testing
• Experience in all phases of Software Development Life Cycle (SDLC) Project Analysis, Requirements, Design Documentation, Development, Unit Testing, User Acceptance Testing, Implementation, Post Implementation Support and Maintenance.
• Strong experience in performance tuning, debugging and error handling of mappings, sources and targets for better performance and determining the performance bottlenecks.
• Extensive database experience and highly skilled in Oracle.
• Expertise in using Relational and Dimensional Modeling techniques like Star, Snowflake Schema, Fact and Dimensional Tables.
• Extensive experience in designing and developing complex Mappings using transformations like Source qualifier, Aggregator, Expression, Connected & Unconnected lookup, Filter, Joiner, Sequence generator, Sorter, Router, Normalizer and Update Strategy.
• Implemented complex business rules in Informatica by creating Reusable transformations to reduce the development time and complexity of mappings.
• SCD Management including Type 1, 2, 3, Hybrid Type 3, De - normalization, Cleansing, Conversion, Aggregation, Performance Optimization etc.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling and production support.
• Experience in integration of various data sources like Oracle, DB2, Sybase, Teradata, SQL server and MS access and non-relational sources like flat files into staging area.
• Worked on Tpump, Mload, Fload, TPT and BTEQ scripts to load the data into Teradata tables.
• Provided performance tuning and physical and logical database design support in projects for Teradata systems.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Hands on experience on informatica web services (WSDL/XSLT/XML).
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Experience in creating pre-session and post-session scripts to ensure timely, accurate processing and ensuring balancing of job runs.
• Knowledge in developing reports using Business Intelligence tools like Business Objects and Cognos.
• Experienced in Agile /Scrum based system development.
• Maintained outstanding relationship with Business Analysts and Business Users to identify information needs as per business requirements.
• Enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills and leadership capabilities with high level of adaptability.

TECHNICAL SKILLS:

Software: Informatica ETL SSIS Tableau Hadoop Hive Mule Soft Qlikview Crystal Reports

Languages: Proficient in SQL PL/SQL Python UNIX Shell Scripting HTML

Databases: Oracle RDBMS MySQL PostgreSQL SQL Server Management Studio

Tools: JIRA VSTS TOAD Jenkins Eclipse Maven Git HUB MS Visio

Analysis: Business Process Modeling Sequence Diagrams Gap Analysis Decision Modeling Data Mapping

Testing Tools: TOAD SQL*Plus Rational Clear Quest Rational Test Manager HP Quality Center 11

Methodologies: Agile/ Scrum, Waterfall

PROFESSIONAL EXPERIENCE:

Confidential, West Des Moines, IA

Sr. Informatica Developer

Responsibilities:

• Converting the existing Oracle PL/SQL packages/ procedures which load the data, into Informatica workflows for an efficient management and monitoring.
• Providing support to existing PL/SQL packages/procedures for business changes and also monitoring the daily jobs.
• Developing Oracle Views for easy access to the Tableau dashboards to display the data for data analysis purpose.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Developing workflows to load the data into BDR (business data repository) from different sources through Informatica.
• Experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions data modeling.
• Gathering requirements for new workflows to load the data for different projects like Genscape, ERCOT, DTN etc. which are typical data sources for estimating the usage.
• Being a part of Data Analytics team involved in end-to-end lifecycle of Power Generation Project, AMI data load, from requirement gathering to reporting.
• Developed Informatica workflows for the Genscape, ERCOT and DTN data loads.
• Gather the requirements and define the objective of the database, Gather Data, Organize in tables and specify the Primary Keys, Create Relationships among Tables for Relational Database Design.
• Fine tuning the existing Pl/SQL packages for a better performance and reducing the time to load the data.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica graphs.
• Involving in Functional Testing & Regression Testing.
• Performing backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases.
• Involving in writing complex SQL queries to verify data from Source to Target
• Performed data analysis by using Hive to retrieve the data from Hadoop cluster, SQL to retrieve data from Oracle database.
• Administering Informatica tool to provide access to different users and also for the upgraded the version from Informatica 9.6.1 to 10.1.1.
• Coordinating with the DBA team for table performance and developing the strategy for granting roles to different users in the enterprise.
• Creating data driven alerts on Oracle to alert the business users according to the requirement by creating different Oracle Procedures.
• Providing Informatica Production support to the enterprise for business changes and also monitoring as well as alerting the status of the daily workflow runs.

Confidential, Boston, MA

Sr. Informatica Developer

Responsibilities:

• Collaborated with Business analysts for requirements gathering, analysis, ETL design and development for extracting data from the heterogeneous source systems like MS SQL Server, Oracle, flat files, XML files and loading into Staging and Data Ware House Star Schema.
• Prepared technical design/specifications for data Extraction, Transformation and Loading.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
• Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD
• Devised a POC to demonstrate how HADOOP can be integrated with existing data warehouse to improve the performance.
• Deployed HDInsight clusters and developed SQOOP Scripts to import / export data between SQL Server and clusters.
• Created HIVE tables on HDFS data and wrote HIVE queries to access them
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Involved in massive data cleansing prior to data staging. Used informatica Web Services to support the feeds.
• Designed and developed ETL routines, using Informatica Power Center within the Informatica Mappings, usage of Lookups, Aggregator, Java, XML, Ranking, Mapplets, connected and unconnected stored procedures / functions / Lookups, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers were extensively done.
• Created sequential/concurrent Sessions/ Batches for data loading process and used Pre & Post Session SQL Script to meet business logic.
• Configured workflows with Email Task, which would send mail with session, log for Failure of a sessions and for Target Failed Rows.
• Extracted data from various sources (Flat files, SQL Server, DB2 Databases)
• Assisted in Batch processes using Fast Load, BTEQ, UNIX Shell and Teradata SQL to transfer cleanup and summarize data.
• Experience on implementation of Web Service providers and consumer transformation
• Tuning the Mappings for Optimum Performance, Dependencies, Batch testing Batch Design and TWS scheduling. Created BTEQ (Basic Teradata Query) scripts to generate Keys.
• Worked in Agile/Scrum environment.
• Prepared test scenarios and test cases in HP Quality Center and involved in unit testing of Performed Configuration Management to Migrate Informatica mappings/sessions /workflows from Development to Test to production environment.
• Performed workshops on Informatica cloud.

Environment: Informatica Power Center 9.5, Oracle 11g, Toad 10.1.1, SQL 2012 R2, Control-M, Teradata 12.0, Flat Files, DB2, on Z/OS, UNIX, HP Quality Center, Agile/ Scrum.

Confidential, Plano, TX

Informatica Developer

Responsibilities:

• Worked with Data Modeler to understand the business requirements and business rules
• Prepared ETL Specifications to help develop mapping.
• Extracted data from various sources (Flat files, SQL Server, DB2 Databases).
• Designed and developed Informatica Mappings and sessions based on business user requirements and business rules.
• Worked extensively on Source Analyzer, Mapping Designer, and Warehouse Designer Developed several Mappings using corresponding Sources, Targets and Transformations, Web Services.
• Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Created mappings to read from Flat files, RDBMS and to load into RDBMS tables.
• Based on business Rules Debugged code, tested and validated data after processes are run in development.
• Performing manual testing by performing the operations mentioned in the design steps. Compared the expected results with the actual outcome and recorded the results.
• Involving in Functional Testing & Regression Testing
• Prepared and maintained mapping specification documentation.
• Modified the existing mappings for the updated logic and better performance.
• Developed Logical Data Flow Diagrams in Visio for every mapping that is developed. Assisted QA Team to fix and find solutions for the production issues.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.

Environment: Informatica 9.1, DB2, ERWIN, Oracle 10g, SQL Server 2012, Visual Basic.Net, MS Access, Business objects 6.5, Toad, SQL, UNIX, Java, Windows 2000, HP Quality Center.

Confidential, Chicago, IL

ETL Informatica Developer

Responsibilities:

• Gathered business scope and technical requirements.
• Worked with Power Center Designer tools in developing mappings and Mapplets to extract and load the data from flat files and Oracle (source) to Oracle (target).
• Created different transformations for loading the data into targets using various transformations.
• Created reusable transformations and Mapplets to use the transformation logic in multiple mappings.
• Worked on Repository manager to create and manage user profiles.
• Wrote Data loading stored procedures, functions using PL/SQL from Source systems into operational data storage.
• Scheduled Sessions on the Informatica Server using Informatica workflow Manager.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Involved in fine tuning queries for better performance (includes indexing and pre-joining and materializing views).
• Used Teradata utilities like MultiLoad, Tpump, and Fast Load to load data into Teradata data warehouse from Oracle and DB2 databases.
• Created views and altered some of the dimensional tables to satisfy their reporting needs.
• Created reports like, Reports by Department, Reports by Supplier, Reports by Period, Demographic reports and Comparative reports.
• Modified old crystal reports by adding new business requirements using SSRS and Create reports in SQL server using SSRS as per the requirements provided by the Front End users.
• Created different types of reports such as Master/Detail, Cross Tab and Chart.
• Solved Various Defects in Set of wrapper Scripts which executed the Teradata BTEQ, MLOAD, FLOAD utilities and Unix Shell scripts.
• Used Analyzer and Explorer to view reports from different prospect like Slice and Dice and Drill down.
• Worked on Unstructured Data Transport UDT.
• Involved in Unit testing, System testing to check whether the data loading into target is accurate, which was extracted from different source systems.

Environment: Informatica 9.1, XML, DB2, Workflow Manager, Informatica Power Connect, Workflow Monitor, Ms-Access 2007, Ms-Visio, Teradata, Oracle 9i, SQL Server 2000, PL/SQL Developer,VB.Net, Business objects 6.5,Toad, Windows 2000, UNIX, C#.