SUMMARY:

• Over 8 years of experience in Requirement gathering, Gap analysis, Designing, Coding, testing, implementation, Production support, Resource Management in Data warehousing with business knowledge of Banking, Insurance, Pharmaceutical & Telecom.
• Good working Experience in SDLC (Software Development Life Cycle) methodologies like Waterfall and Agile.
• 2.5 year of real - time development experience using CDC tool Informatica Power exchange 9.6.1/9.5.1.
• Experience in development and design of ETL methodology for supporting data transformations and processing.
• Experienced in using ETL tools including Informatica PowerCenter (10.1/9.5.1/9.1/8.5/8.1.1 ), Power Mart and PowerExchange, Repository Manager and Administration console.
• Worked with various transformations like Normalizer, Expression, rank, Filter, Group, Aggregator, Lookup, Joiner, Sequence Generator, Sorter, Sql, Stored Procedure, Update Strategy and Source Qualifier.
• Experienced in Teradata SQL Programming, procedure and Tuning.
• Worked with Teradata utilities like Fast Load and Multi Load and Tpump and Teradata Parallel transporter.
• Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experience in Designing and developing the complex mappings from various Transformations like Source Qualifier, Joiners, Aggregator, Routers, Filters, Expressions, Lookups, Sequence Generators, Update Strategy, Java etc.
• Experience in Performance tuning of targets, sources, mappings and sessions. And experience in Error handling.
• Experience in using UNIX shell scripts. Created script for file cleaning, scheduling job.
• Hands on exposure on UNIX Environment and experience in using third party scheduling tools like Autosys.
• Experience in Data warehouse OLAP reporting using various BI tools Business Objects.
• Worked with Teradata loading utilities like Multi Load, Fast Load, TPump and BTEQ.
• Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow.
• Exposure to Microsoft Azure Cloud database and high availability configurations.
• Good knowledge in Amazon Web Service (AWS), components - EC2, S3 Bucket.
• Worked on Production support L2 and L3 , Onsite-offshore model and on call support.

TECHNICAL SKILLS:

ETL: Informatica PowerCenter (10.1/9.6.1/9.1/8.6 ), Informatica PowerExchange (9.6.1/9.5.1 )

Hadoop: Sparks SQL, Hive, HDFS

Scheduling Tools: Autosys, Control M

RDBMS: DB2, Oracle 12g/11g/10g, SQL Server 2008/2012, MySQL, Teradata 14/12

Data Modeling: Erwin 7.5, Entity Relationship and Dimensional (Star, Snowflake Schema)

UNIX: Shell scripting

Defect Tracking Tools: HP Quality Center, Bug Tracker

Operating Systems: Windows XP/2000/9x/NT, UNIX

Cloud Computing: Amazon Web Services (AWS), S3, Redshift

Other Tools: Notepad++, Toad, SQL Navigator, Microsoft Excel, MS Visio, Microsoft Visual Studio 2015, Power Point

PROFESSIONAL EXPERIENCE:

Confidential, Branchburg, NJ

Sr. Informatica/Teradata Developer

Responsibilities:

• Worked with business analyst to understand business requirement in order to transform business requirements into effective technology solutions. Also involved in robust teamwork with Managers, Architects and Data Modelers to understand the business process and functional requirements.
• Created high-level, low-level design documents, ETL specification documents, data model document and test document.
• To implement business rules created robust mapping, mapplets and reusable transformation using Informatica Power Center and its different transformation including Joiner, Look-up, Rank, Filter, Router, Expression, Aggregators, Sequence Generator, Sorter, Update Strategy.
• Improved and enhanced various jobs in different cycles by creating reusable and common job techniques, extensively used parameters at run time to push in job related parameters.
• Worked with connected and unconnected look-up and configured the same for implementing complex logic.
• Worked on various Salesforce.com objects like Accounts, Contacts, Cases, Opportunity.
• Worked on performance tuning by identifying the bottlenecks in Sources, Targets, and Mapping. Enhanced Performance on Informatica sessions using large data files by using partitions.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Development of scripts for loading the data into the base tables in EDW using FastLoad, Multiload and BTEQ utilities of TERADATA.
• Worked on TERADATA SQL, BTEQ, MLoad, FastLoad, and FastExport for Ad-hoc queries, and build UNIX shell script to perform ETL interfaces BTEQ, FastLoad or FastExport. Created numerous Volatile, Global, Set, Multiset tables. Created batch jobs for Fast Export
• Created Unix Shell Scripts for ETL jobs, session log cleanup, dynamic parameter and maintained shell scripts for data conversion
• Managed the authenticity of jobs by checking-in & checking-out code from Star Team code versioning tool.
• Maintaining daily batch cycle and providing 24-hour Production support.
• Developed business object reports like universe, crystal reports for business validation.
• Worked with Offshore team to oversee the development activity, reviewed code to make sure it confirms the standard programming practice at USAA.
• Good working experience in Tableau Dashboard and extensive uses of Tableau features like Data blending, Extracts, Parameters, Filters, Calculations, Context Filters, Hierarchies, Actions, Maps etc.
• Build number of UNIX Shell scripts for PL/SQL programs to schedule them on Control M.

Environment: Informatica PowerCenter 10.1/9.6, PowerExchange 10.1/9.6, Oracle 12g, Teradata 14, SQL/PLSQL, IDQ, Salesforces, Server 2014, UNIX/LINUX, Tableau, Control M, Putty, Rally.

Confidential, Tampa, FL

Informatica/Teradata Developer

Responsibilities:

• Translated business requirements into SQL query to implement performance optimization on advertiser side.
• Created Data Mapping Documents as per business rules applied in source data to target data.
• Responsible for creating the Design document and design flow of the data in the project.
• Responsible for quality of the metadata delivers business value with domain values are normalized, redundancy eliminated.
• Experience in Extraction, Transformation and Loading (ETL) data from various data sources into Data Marts and Data Warehouse using Informatica power center components (Repository Manager, Designer, Workflow Manager, Workflow Monitor and Informatica Administration Console).
• Strong Experience in developing Sessions/Tasks, Worklets and Workflows using Workflow Manager Tools Task Developer, Workflow & Worklet Designer.
• Generated ad hoc SQL queries using joins, Database connections and transformation rules to fetch data from Oracle database and SQL Server.
• Wrote numerous BTEQ scripts to run complex queries on the TERADATA database. Used volatile table and derived queries for breaking up complex queries into simpler queries.
• Data expert and SME in multiple areas that includes Consolidated Data repository, Customer Data Warehouse, IVR data repository and Metering Database.
• Reviewed normalized/Denormalization schemas for effective and optimum performance tuning queries and data validations in OLTP environments.
• Responsible for developing the mapping, session and workflow as per the dataflow and load the data in Oracle database.
• Hands on experience creating, converting oracle scripts (SQL, PL/SQL) to TERADATA scripts.
• Solely responsible for migration of the ETL code to different environments - Dev, Test and Prod.
• Created the DDL scripts and implemented in different environments.
• Enhanced the ETL mapping to improve the performance.
• Worked on Informatica PowerCenter and used different transformations - Filter, Router, Joiner, Update Strategy (Static and Dynamic), Aggregator.
• Created parameter files and passed connection string and parameter values using parameter files.
• Worked on Unix shell scripting to transfer the files to different server locations.
• Validated and tested the mappings using Informatica Debugger, Session Logs and Workflow Logs.
• Created detail Unit test plans and performed error checking and testing of the ETL procedures using SQL queries, filtering out the missing rows into flat files at the mapping level.
• Developed User Defined Functions and Created Materialized Views for high availability of data.
• Developed mapping to load Fact and Dimension tables, for type 1 and type 2 dimensions and incremental loading and unit tested the mappings.
• Scheduled and ran Workflows in Workflow Manager and monitored sessions using Informatica Workflow Monitor.
• Wrote, tested and implemented TERADATA Fast load, Multi load and BTEQ scripts, DML and DDL.
• Azure cloud is a HA configured (high availability) database available in East and Central regions with SLA-95.5%. Any downtime or performance issues were worked with Microsoft and fixed immediately.
• Supported the project in different phases - Dev, SIT, UAT.
• Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments.
• Created Groups, roles, privileges and assigned them to each user group.
• Creation and maintenance of Informatica users and privileges.
• Worked on SQL queries to query the Repository DB to find the deviations from Company’s ETL Standards for the objects created by users such as Sources, Targets, Transformations, Log Files, Mappings, Sessions and Workflows.
• Development of scripts for loading the data into the base tables in EDW using FastLoad, Multiload and BTEQ utilities of TERADATA.
• Ensure that all support requests are properly approved, documented, and communicated using the MQC tool. Documenting common issues and resolution procedures.
• Monitored the incremental data loads and scheduled jobs in Autosys in different phases of the project.
• Supported the project during warranty phase and fixed critical issues in time.

Environment: Informatica PowerCenter 9.6, Informatica PowerExchange 9.6, Teradata 12, Oracle 11g, UNIX Shell Scripting, SQL Server, Microsoft Azure Cloud SQL Server Database, Autosys Scheduling Tool, Putty, SQL Developer, IDQ.

Confidential, Minneapolis, MN

ETL Informatica Developer

Responsibilities:

• Involved in various phases of SDLC from requirement gathering, analysis, design, development and testing to production.
• Assisted in creating test data and test cases and execute function system tests as needed and tested the application by writing SQL Queries and creating pivot views as to perform back-end testing.
• Worked on Informatica Power Center tools - Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Experience translating business problems into actionable data quality initiatives
• Meeting with business users and defining Functional and Technical business requirements.
• Extensively created Reusable Transformations and Mapplets to implement the business logic for loading to the target database.
• Worked with Informatica Data Quality toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ.
• Extensively used all the Transformations like source qualifier, aggregator, filter, joiner, Update Strategy, Unconnected and connected Lookups, Router, Sequence Generator etc. and used transformation language like transformation expression, constants, system variables, data format strings etc.
• Extensively worked on Workflow Manager and Workflow Monitor to create, schedule, monitor Workflows, Worklets and various tasks like command, assignment, control and session tasks
• Extracted data from various source systems like Oracle, Teradata, SQL Server and flat files as per the requirements.
• Utilized T-SQL daily in creating customs view for data and business analysis.
• Utilize Dynamic T-SQL within functions, stored procedures, views, and tables.
• Designing the ETL process flows to load the data into Oracle Database from Heterogeneous sources.
• Implemented Slowly Changing Dimension Type 1 and Type 2 for inserting and updating Target tables for maintaining the history.
• Developed post-session and pre-session shell scripts for tasks like merging flat files after Creating, deleting temporary files, changing the file name to reflect the file generated date etc.
• Optimized query performance, session performance.
• Designed and developed UNIX shell scripts as part of the ETL process to compare control totals, automate the process of loading, pulling and pushing data from and to different servers.
• Involved in Structural and Functional Testing and Migrating the Code to Production.
• Onsite - Offshore team coordination.

Environment: Informatica PowerCenter 9.5.1/9.1, Informatica PowerExchange 9.5/9.1, IDQ, Oracle 10g, TOAD 9.0, SQL Developer, Data Quality, PL/SQL, T SQL, UNIX.

Confidential, Washington, DC

Informatica Developer

Responsibilities:

• Analyzed the designed dimension model and laid out the steps for the data extraction, business logic implementation & loading into targets.
• Designed and developed many simple as well as Complex Mappings, from varied transformation logic using Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
• Designed the ETL processes using Informatica tool to load data from File system and Oracle into the target Oracle Database.
• Involved in identifying the sources for various dimensions and facts for different data marts according to star schema design pattern.
• Developed mappings & Mapplets to load data from various sources using standard ETL transformations to store the data in the staging area and target tables.
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level
• Extensively used both Connected and Un connected Lookup transformations
• Developed slowly changing dimension, according to the data mart schemas.
• Developed multiple Workflows using work flow manager for initial loading, historical data loading, using sessions, worklets, commands, decisions, events and timers.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files
• Executed sessions, sequential and concurrent batches for proper execution of mappings and sent e-mail using workflow manager.
• Developed Re usable Transformations, and Re-Usable Mapplets
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Involved in Unit testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.

Environment: Informatica PowerCenter 8.6.5, Oracle 10g, SQL, PL/SQL, TOAD, Teradata, Windows XP, UNIX.

Confidential, Bentonville, AR

Informatica Developer

Responsibilities:

• Involved in designing and customizing logical and physical data models for Data warehouse supporting data from multiple sources on real time.
• Used Star Schema approach for designing of Data Warehouse using Erwin.
• Designed and developed Informatica mappings, enabling to Extract, Transform and Load the data into target tables.
• Extensively worked on Informatica Designer and Workflow Manager.
• Extensively used almost all of the transformations of Informatica including source qualifier, expression, filter, aggregator, rank, Lookups, Stored Procedures, sequence generator, joiner, Update Strategy and others.
• Worked with Memory cache for improving throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Developed Slowly Changing Dimension (SCD) mappings.
• Developed Sessions, Worklets using Informatica Workflow Manager.
• Extensively worked in the Performance tuning of the Programs, Procedures and Processes.
• Translated business requirements into data warehouse design.
• Worked in modules with relational E/R and Dimensional data modeling in large transaction.
• Worked on technical Documentation of existing and proposed models.
• Worked closely with DBA and developers during planning, analyzing and testing phase.
• Running the SQL scripts from TOAD and creating Oracle Objects like tables, Views, Indexes, sequences and Users. SQL coding for problem resolution and performance optimization
• Participated in identifying scope of the project, planning and development with another team.
• Worked with various IT and management teams with the schedule.
• Prepared testcases and performed Unit testing. Created test cases and test scenarios and documented actual results; involved in system testing of overall processes; compared actual results to expected results; and wrote Test Plans and created Test Cases effectively using Quality Center.
• Worked on data cleansing and query tuning. Involved in analyzing the source data coming from different data sources like Oracle, Flat Files, XML and SQL Server and identifying data anomalies in operational data.
• Worked in the data mapping, designing phase and deploying the mappings
• Trouble shot development related issues which arose at the time of UAT.
• Developed Pre and Post SQL scripts, PL/SQL stored procedures and functions.
• Responsible for error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor.
• Used mapping Parameters and Variables to pass the values between sessions.
• Developed Informatica Mappings and Sessions based on user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Involved in analysis, solution and low-level design.

Environment: Informatica PowerCenter 8.1, Windows 2000, Oracle 10g, SQL Server 2000, MS Suite, AIX, Autosys, Putty, Harvest, Axiom, TFS.