EXPERIENCE SUMMARY:

• 5+ years of progressive experience in the IT industry in designing and developing Data Warehouse applications using ETL and Business Intelligence tools like Informatica PowerCenter and Teradata.
• Experienced in Installation, Configuration, and Administration of Informatica Power Center Client/Server.
• Involved in Understanding and translating the business requirements and to High Level and Low level design for ETL processes in Informatica .
• Experience inShell Scripting and scheduling using Tivoli.
• Trained in AWS developer associate.
• Knowledge in Snowflake Database.
• Developed UNIX shell scripts for automation of daily loading with Tivoli scheduling.
• Worked with Netezza database to implement data cleanup, performance - tuning techniques.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Experience with Netezza Database integration with Informatica and load process with Netezza Bulk load utilities like Netezza Bulk reader and Bulk writer.
• Involved in Informatica Upgrade from 9.6 to 10.2.
• Knowledge in AWS and DEVOPS.
• Knowledge in Amazon REDSHIFT.
• Develop batch processes for financial reporting applications and modules using shell scripts on Netezza database, with partitions and sub-partitions.
• Experienced with informatica PowerExchange for loading/retrieving data from main frame system.
• Experience in Performance Tuning of mappings, ETL Proceduresand process .
• Experienced in complete life cycle Implementation of data warehouse.
• Ability to write complex SQLs needed for ETL jobs and analyzing data, and is proficient and worked with databases like Oracle 11x/10g, SQL Server, MSSQL, Excel sheets, Flat Files and XML files.
• Ability to meet deadlines and handle multiple tasks, work under both Agile and Waterfall methodologies.
• Expertise inAdministration tasks including Importing/Exporting mappings, copying folders over the DEV/QA/PRD environments, managing Users, Groups, associated privileges and performing backups of the repository .
• Developed Complex mappings from varied transformation logics like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy and more.
• Well Experienced in doing Error Handling and Troubleshot.
• Good exposure toDevelopment, Testing, Debugging, Implementation, Documentation, End-user training and Production support.
• Expertise in doingUnit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Mappings.

TECHNICAL SKILLS:

Data Warehousing: Informatica Power Center 9x/8xRepository Admin console, Repository Manager, Designer, Workflow Manager, workflow Monitor.NZSQL, Aginity Workbench Netezza

Databases: Oracle11x/10g, DB2,MSSQL Server, Netezza.

Data Modeling: ERWIN, Star Schema, Snow Flake Schema, Dimension DataModeling, Fact Tables, Dimension Tables.

Programming: C, Visual Basic, Unix Shell Scripting, SQL, HTML, XML, NZSQL.

Environment: Windows XP, Win NT, UNIX .

Other Tools: SQL*Plus, Toad, SQL Navigator, Putty, WINSCP, Ms-Office, SQL Developer And NZSQL.

PROFESSIONAL EXPERIENCE:

Confidential, PITTSBURGH, PA

ETL/ Analytics Developer

Responsibilities:

• Worked with architect, business managers to understand the requirement and source system in order to prepared design documents specifying the various ETL approaches, pros and cons of the different approaches with suggestion of the best approach.
• Involved in the designing of Dimensional Model and created Star Schema using E/R studio.
• Extensively worked with Data Analyst and Data Modeler to design and to understand the structures of dimensions and fact tables and Technical Specification Document.
• Worked extensively on Informatica designer to design a robust end-to-end ETL process involving complex transformation like Source Qualifier, Lookup, Update Strategy, Router, Aggregator, Sequence Generator, Filter, Expression for the efficient extraction, transformation and loading of the data to the staging and then to the Data Mart (Data Warehouse) checking the complex logics for computing the facts.
• Extensively used the reusable transformation, mappings and codes using Mapplets for faster development and standardization.
• Used reusable Session for different level of workflows.
• Involved in Performance Tuning in Informatica for source, transformation, targets, mapping and session.
• Created variables and parameters files for the mapping and session so that it can migrate easily in different environment and database.
• Performed Informatica upgrade from V9.6 to V10.2
• Experience in creating Deployment groups (Static and Dynamic) and migrate them from Dev to QA/PROD.
• Involved in POC of Push Down Optimization (PDO) technique.
• Designed various tasks using Informatica workflow manager like session, command, email, event raise, event wait and so on.
• Design the architecture for production support in order to scheduling the tasks (without any manual intervention) using Unix Shell Scripting.
• Used Unix Command and Unix Shell Scripting to interact with the server and to move flat files and to load the files in the server.
• Developed the SQL scripts for the business rules using Unix Shell and NZSQL for Netezza.
• Used NZSQL and NZLOAD scripts for day-to-day loading and migration activities.
• Used Informatica Power Exchange for loading/retrieving data frame system.
• Hands on experience with Informatica Metadata Manager.
• Used analytical and Windowing functions of Netezza to implement complex business logic
• Experience in schedule Informatica jobs using file dependencies in Tivoli enterprise scheduler tool.
• Responsible for file archival using Unix Shell Scripting
• Used DB visualizer to access the data base

Environment: Informatica Power Center 9.6, 10.2, Windows, Netezza, DB visualizer, Aginity workbench for Netezza, Unix, Putty, Winscp, Tivoli

Confidential, Portland, OR

ETL Developer

Responsibilities:

• Participated in design sessions and partnered closely with ETL Architect on design and then worked closely to ensure design decisions are implemented out by the development team.
• Expertise in of the Extract, Transform and Load process and development of transformation standards and processes using Informatica best practices.
• Coordinated with SME for technical clarifications.
• Developed technical design document.
• Interact with Release Management, Configuration Management, Database Modeling Support, other Development teams and Operations as required.
• Lead the creation of all design review artifacts during project design phase, facilitate design reviews, capture review feedback and schedule additional detailed design sessions as necessary.
• Developed reusable transformation objects such as mapplets and user defined functions to avoid duplication of metadata, reducing the development time.
• Developed complex Mappings using Transformations on the extract data according to the Business Rules and User requirements.
• Loaded Data into target Data warehouse from 12 different sources.
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouse Netezza tables using Informatica Workflow Manager.
• Used workflow monitor to see the work flows running and get the session properties and session log.
• Developed all the mappings according to the design document and mapping specs provided and performed unit testing.
• Developed Unit Test Cases to ensure successful execution of the data loading processes.
• Created documentation for both functional and technical flows using Visio.
• Involved in creation of mapping documents and flow charts based on the run time in prod (production job run book).
• Responsible for Testing and Validating the Informatica mappings against the pre-defined ETL design standards.
• Post Warranty support for newly rolled enhancements into production.

Environment: Informatica Power Center 9.6, Informatica Data Studio, Windows, Oracle,Toad, Unix, PuttyWinscp, Tivoli

Confidential

Data Warehouse Consultant

Responsibilities:

• Designing the dimensional model and data load process using SCD Type 2 for the quarterly membership reporting purposes.
• Derived the dimensions and facts for the given data and loaded them on a regular interval as per the business requirement.
• Extracted data from multiple sources such as Oracle, XML, and Flat Files and loaded the transformed data into targets in Oracle, Flat Files.
• Designing and coding the automated balancing process for the feeds that goes out from data warehouse.
• Implement the automated balancing and control process which will enable the control on the audit and balance and control for the ETL code.
• Improving the database access performance by tuning the DB access methods like creating partitions, using SQL hints, and using proper indexes.
• All the jobs are integrated using complex Mappings including Mapplets and Workflows using Informatica power center designer and workflow manager.
• Used Teradata utilities such as multi load, T-Pump to load data into Teradata.
• Use debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations, and create mapplets that provides reusability in mappings.
• Analyzing the impact and required changes to in corporate the standards in the existing data warehousing design.
• Following the PDLC process to move the code across the environments though proper approvals and source control environments & Source control using SCM.

Environment: : Informatica Power Center 9.1/8.5, Power Exchange, UNIX, Oracle 10g, SQL Server 2008, Teradata SQL Assistant, DB2.

Confidential

Programmer Analyst

Responsibilities:

• Provide solutions for UNIX environment based failed jobs.
• Used various transformations in Informatica mappings to reflect the logics involved in Netezza stored Procedures.
• Written complex PL/SQL procedures, functions, triggers for specific requirements
• Developing sessions, workflows which involve command tasks to invoke the ETL jobs from UNIX shell scripts.
• Designed various ETL jobs for pulling data from various legacy systems and for loading into the integrated database.
• Analyzing the existing packages, shell scripts and converting into Informatica with some enhanced functionality based on requirements by business users.
• Interact with TWS through UNIX commands to perform scheduling operations on the tool for enhanced functionality.
• Used Informatica Designer to create complex mappings using different transformations like filter, Router, lookups, stored procedure, joiner, update strategy, expression, sequence Generator and aggregator transformations to pipeline data to Data Warehouse.
• Designed and developed a security model for databases in order to prevent unauthorized attacks.
• Worked on Teradata SQL queries, Teradata Indexes, MDM Utilities such as M load, Tpump, Fast load and Fast Export.

Environment: Informatica Power Center, UNIX, BMC Remedy tool, Teradata SQL Assistant, TWS, Teradata.