PROFESSIONAL SUMMARY:

• Over 7 years of experience in the IT field with extensive Data Warehousing implementations and data integration experience in developing ETL mappings and scripts using Informatica PowerCenter 10.1/9.6.1/9.5.1 /8.6.1/7.1 PowerExchange 9.6/9.5.1/8.6 Informatica IDQ/IDE 9.6, Master Data Management (MDM) Oracle 11g/10g - SQL, Teradata, DB2 and PL/SQL Level, and Unix & Shell Scripting.
• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Extensive experience in developing ETL applications and statistical analysis of data on databases ORACLE, DB2, Teradata, Netezza, MySQL, PostgreSQL and SQL Server.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
• Extensively worked on Data extraction, Transformation and Loading data from various sources like Oracle, SQL Server and Flat files (.txt, .dat, .csv & xml).
• Proficient in Optimizing Database querying, data manipulation and population using SQL PL/SQL and Utilities in Oracle 11g/10g/9i, Teradata 13/12/V2R6, DB2 UDB and SQL Server 2008/2000, Sybase databases.
• Experience in integration of various data sources like Oracle, DB2, Sybase, SQL server and MS access and non-relational sources like flat files into staging area and DWH DB.
• Experience in creating Reusable components like transformation, mapplets and tasks.
• Loading data from various data sources and legacy systems into Teradata production warehouse using utilities BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD.
• Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages.
• Excellent working knowledge of UNIX shell scripting, job scheduling on multiple platforms, experience with UNIX command line and LINUX.
• Worked on CDC using Informatica PowerExchange to load data in Real-time mode.
• Proficient in interaction with the business users by conducting meetings with the clients in Requirements Analysis phase.
• Assign work and provide technical oversight to onshore and offshore developers.
• Worked on workflow parameters & variables to run the workflow dynamically.
• Have good experience by communicating with customer's regarding the requirements, issues & tasks.
• Created test cases for the mappings developed and then created unit test plan document.
• Excellent communication, documentation and presentation skills.

TECHNICAL SKILLS:

Agile, Water: Fall

DataBases: Oracle,Teradata,DB2, MS-SQL Server, MYSQL, MS-Access

Operating Systems: Windows, Linux, Unix

ETL Tools: Informatica, Talend, Pentaho

PROFESSIONAL EXPERIENCE:

Confidential, Monroe, Louisiana

ETL/Informatica Developer

Responsibilities:

• Involved in gathering requirement from business customers and developed requirement document and ETL specification.
• Deployed Talend jobs into server and schedule through Talend Job Conductor tool. ¬ Work independently to develop ETL Talend Job's.
• Developed ETL Talend complex job's by using components such as tMap, tFilterRow, tJavaRow, etc
• Integrate new data into NOC Data Platform from both internal and external sources.
• Implemented MS Business Intelligence tools including SQL Server Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Involved in developing OLAP cubes by identifying tables (fact and dimension), data source and data source views, attributes and dimension members using SQL Server Analysis Services (SSAS)
• Experienced in designing and developing SSRS 2012 reports using data from SSAS Cubes and Relational database data sources.
• Skilled in parsing Flat Files by using delimiter, regular expression or positions.
• Worked on Informatica Cloud Services (ICS) to load data from Azure DB to Azure DB and Oracle
• Designed, Installed, Configured core Informatica/Siperian MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, Data Modeling.
• Created transformations like Expression, Lookup, Joiner, Rank, Update Strategy and Source Qualifier Transformation using the Informatica designer.
• Extensively involved in performance tuning of the Informatica ETL mappings by using the caches and overriding the SQL queries and also by using Parameter files.
• Using Talend extracted the information from various disparate data sources including but not limited to Oracle, Netezza, MySQL, Mongo, Hadoop, MSSQL, and flat files and loaded into destination.
• Expertise includes taking any incoming data set and applying various transformation logic to manipulate data as per business needs.
• Analysing data using SQL Data cleansing for web end applications.
• I Specialize in developing SQL queries with hands on experience in writing complex queries for staging clean data sets to front end web applications.
• Define physical data models for new source integration, balancing performance and storage through query optimization. Support and troubleshoot data and processes residing around the NOC Data Platform, including emergency break fix and testing that may occur.
• Ability to understand business need and translate that into desired output.
• Administrating and integrating various data sources to our centralized NOC Data Platform.
• Provide access to new data sources into NOC Data Platform using ETL tools and processes.
• Exhibits an advanced understanding of our technology platforms and information systems with an ability to run, troubleshoot, QA and deliver recurring reporting on a set schedule.

Environment: ETL, SSRS, SSIS, SSAS, Informatica Power Center 10.1/9.6.1/9.5.1 , Talend 6.2, Netezza 3.0, HDFS, Hive, sqoop, putty 0.64, Teradata 14.0, SQL Server 2014, Autosys Scheduler Tool, Netezza, UNIX, Toad, PL/SQL, DB2.

Confidential, Sunnyvale, CA

ETL/Informatica Developer

Responsibilities:

• Involved in Design and develop the architecture for all data warehousing components e.g. tool integration strategy; source system data ETL strategy, data staging, movement and aggregation, information and analytics delivery and data quality strategy.
• Designed and developed ETL and Data Quality mappings to load and transform data from sources such as DB2, Oracle and Sybase to Data warehouse using Power Center and IDQ/IDE.
• Extensively used Informatica Data Quality (IDQ) transformations like Match, Consolidation, Exception, Parser, Standardizer and Address Validator.
• Developed IDQ Match and Merge strategy and Match and consolidation based on customer requirement and the data.
• Built several reusable components in IDQ/IDE using Parsers Standardizers and Reference tables.
• Performed data profiling and analysis of various objects in SalesForce.com (SFDC) using IDQ and MS Access database tables for an in-depth understanding of the source entities, attributes, relationships, domains, source data quality, hidden and potential data issues, etc.
• Worked with the Business Analysts on IDQ - Data Profiling, Data Validation, Standardization and Data Cleansing for the Oracle 12c data migration to rebuild and enhance the business rules.
• Also, worked with Business Analysts to modify/enhance rules for physical/mailing addresses using IDQ -Address Validator.
• Developed both one-time and real-time mappings using Power Center 9.6 Power Exchange.
• Registered the Data maps for Real-time CDC Changed Data Capture data in Power Exchange. Worked on Extraction Maps Row Test in Power Exchange Navigator.
• Implemented Change Data Capture (CDC) on Source data from Salesforce.com.
• Extracted various data from SalesForce.com using Informatica 9.6 with Sales Force Adapter.
• Worked on updating Sales Force using external ID and created various objects in Salesforce.
• Used Teradata, SQL assistant for running the SQL Queries to check the data loaded to the Target Tables.
• Worked on design and development of Informatica mappings, workflows to load data into staging area, data warehouse and data marts in Teradata.
• Created new and modified existing Hierarchies in the universes to meet Drill Analysis of the user's reporting needs and Involved in performance tuning and optimization on Business Objects Universes by creating Aggregate tables.
• Performed integrity testing of the Universes (Universe Structure checking, Object parsing, joins parsing, Conditions parsing, Cardinalities checking, Loops checking and Contexts checking) after any modifications to them in terms of structure, classes, and objects.
• Used multi-dimensional analysis (Slice & Dice and Drill Functions) to organize the data along a combination of Dimensions and Drill-down Hierarchies giving the ability to the end-users to view the data from heterogeneous viewpoints.

Environment: Informatica Power Center 9.6, Informatica Power Exchange 9.6, Informatica IDQ/IDE 9.6, Autosys, Hadoop Ecosystem, Data Modelling(Erwin), UNIX, Windows 2007 Professional Client, Sybase, Teradata, Oracle 10i, DB2, SAP Business Objects, Flat files, XML and COBOL, Shell Scripting, Putty, WinSCP and Toad.

Confidential, Pleasanton, CA

ETL/Informatica Developer

Responsibilities:

• Worked with Business Analysts (BA) to analyse the Data Quality issue and find the root cause for the problem with the proper solution to fix the issue.
• Document the process that resolves the issue which involves analysis, design, construction and testing for Data quality issues
• Involved in doing the Data model changes and other changes in the Transformation logic in the existing Mappings according to the Business requirements for the Incremental Fixes
• Worked extensively with Informatica tools like Source Analyzer, Warehouse Designer, Transformation Developer, and Mapping Designer.
• Extracted data from various heterogeneous sources like DB2, Sales force, Mainframes, Teradata, and Flat Files using Informatica Power center and loaded data in target database.
• Created and Configured Landing Tables, Staging Tables, Base Objects, Foreign key relationships, Queries, Query Groups etc. in MDM.
• Defined the Match and Merge Rules in MDM Hub by creating Match Strategy, Match columns and rules for maintaining Data Quality
• Extensively worked with different transformations such as Expression, Aggregator, Sorter, Joiner, Router, Filter, and Union in developing the mappings to migrate the data from source to target.
• Used connected and Unconnected Lookup transformations and Lookup Caches in looking the data from relational and Flat Files. Used Update Strategy transformation extensively with DD INSERT, DD UPDATE, DD REJECT, and DD DELETE.
• Extensively Implemented SCD TYPE 2 Mappings for CDC (Change data capture) in EDW.
• Code walkthrough and Review of documents which are prepared by other team members.
• Involved in doing Unit Testing, Integration Testing, and Data Validation.
• Migration of Informatica maps extensively involved in migration from Dev to SIT and UAT to Production environment.
• Developed tools to automate base tasks using Python, Shell scripting and XML.
• Created data Informatica Cloud synchronization tasks & amp; Tasks flows to extract the data from Salesforce and loading the data from files to Salesforce.
• Developed Unix script to sftp, archive, cleanse and process many flat files
• Created and ran Pre-existing and debug sessions in the Debugger to monitor and test the sessions prior to their normal run in the Workflow Manager
• Extensively worked in migrating the mappings, worklets and workflows within the repository from one folder to another folder as well as among the different repositories.
• Created Mapping parameters and Variables and written parameter files.
• Implemented various Performance Tuning techniques by finding the bottle necks at source, target, mapping, and session and optimizing them.
• Used SQL queries and database programming using PL/SQL (writing Packages, Stored Procedures/Functions, and Database Triggers).
• Worked on Scheduling Jobs and monitoring them through Control M and CA scheduler tool(Autosys).
• Working with an Agile, Scrum methodology to ensure delivery of high quality work with every monthly iteration.
• Responsible for optimization of SQL queries, T-SQL and SSIS Packages.
• Used TOAD to run SQL queries and validate the data in warehouse.
• Worked with the SCM code management tool to move the code to Production
• Extensively worked with session logs and workflow logs in doing Error Handling and trouble shooting.

Environment: : Informatica Power Center 9.6.1/9.1.0 , Informatica Developer Client, IDQ, MDM, Power Exchange, DB2, SAP, Oracle 11g/10g, Hadoop HDFS, Hive, Sqoop, Syncsort, PL/SQL, TOAD, SQL SERVER 2005/2008, XML, UNIX, Windows XP, OBIEE, Teradata.

Confidential

ETL/Informatica Developer

Responsibilities:

• Analyzed the functional specifications provided by the data architect and created Technical System Design Documents and Source to Target mapping documents.
• 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.
• Performed Source System Data Profiling using Informatica Data Explorer (IDE).
• Involved in designing Staging and Data mart environments and built DDL scripts to reverse engineer the logical/physical data model using Erwin.
• Extracted data from SAP using Power Exchange and loaded data into SAP systems.
• Translated the business processes/SAS code into Informatica mappings for building the data mart.
• Implemented pushdown, pipeline partition, persistence cache for better performance.
• Developed reusable transformations and Mapplets to use in multiple mappings.
• Implementing Slowly Changing Dimensions (SCD) methodology to keep track of historical data.
• Assisted the QC team in carrying out its QC process of testing the ETL components.
• Created pre-session and post-session shell scripts and email notifications.
• Involved in complete cycle from Extraction, Transformation and Loading of data using Informatica best practices.
• Involved in Data Quality checks by interacting with the business analysts.
• Performing Unit Testing and tuned the mappings for the better performance.
• Maintained documentation of ETL processes to support knowledge transfer to other team members.
• Extracted data from various heterogeneous sources like DB2, Sales force, Mainframes, Teradata, and Flat Files using Informatica Power center and loaded data in target database.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and automated execution of workflows.
• Involved as a part of Production support.
• Informatica Power Exchange for Mainframe was used to read/write VSAM files from/to the Mainframe.
• Designed Audit table for ETL and developed Error Handling Processes.
• Managed Change Control Implementation and coordinating daily, monthly releases and reruns.
• Responsible for code migration, code review, test Plans, test scenarios, test cases as part of Unit/Integrations testing, UAT testing.
• Used Teradata Utilities such as M load, F load and T pump.
• Used UNIX scripts for automating processes

Environment: Informatica Power Center 9.1.1, Informatica Developer Client, IDQ, Power Exchange, SAP, Oracle 11g, PL/SQL, TOAD, SQL SERVER 2005/2008, XML, UNIX, Windows XP, OBIEE, Teradata

Confidential

SQL Server Consultant

Responsibilities:

• Involved in all phases of SDLC and follows Agile Methodology.
• Created SQL scripts to load the custom data into Development, Test and production Instances using Import/Export.
• Designed DDL and DML for MS SQL Server 2000/2005.
• Created scripts to create custom Tables and Views.
• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views.
• Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Used highly complex TSQL Queries and SQL Scripts to perform efficient data load based on complex Business rules.
• Extensively used TSQL to manipulate and architect to produce results for users. Used multiple join statements to retrieve data from multiple tables.
• Extract Transform and Load source data into respective target tables to build the required data marts.
• Install and configure servers and clients using SQL Server 2005. Create and upgrade SQL databases.
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler
• Experience in Creating stored procedures, views, triggers, user defined functions to in corporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
• Performed day-to-day Database Maintenance tasks including Database Monitoring, Backups, Space, and Resource Utilization Actively involved in Normalization & De-normalization of database.
• Using SQL Server Integration Services (SSIS) to populate data from various data sources
• Actively designed the database to fasten certain daily jobs, stored procedures.
• Optimized query performance by creating indexes.
• Involved in writing SQL batch scripts.
• Writing T- SQL statements for retrieval of data and Involved in performance tuning of TSQL
• Involved in merging existing databases and designed new data models to meet the requirements.
• Create joins and sub-queries for complex queries involving multiple tables. .
• Monitor production Server Activity
• Worked with DTS packages to load the massaged data into Data warehousing system
• Tuned the SQL queries using SQL profiler and involved in tuning the database
• Very pro-actively identifying the problems before user complaints

Environment: : Windows 2000 Advanced Server/Server 2003, SQL Server, MS Access, Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, ETL, MS SQL Server DTS, Upgrade Advisor, DTS Designer Tools .