SUMMARY

• Sr. ETL professional with 8 years of experience in all phases of Data Warehouse Life Cycle, focusing on conceptualizing business needs and translating them into viable technical solutions.
• Proven ability to identify problems, analyze possible solutions and determine best course of action to meet objectives.
• Core experience in developing complete life cycle including requirement gathering, analysis, design, development, testing, implementation and maintenance of Data Warehousing and OLAP Applications using ETL/OLAP Tools.
• Expertise in design, development, testing of mission critical data warehousing applications against high volume data sources using Informatica (Power Center 6.x/7.x/8.6), Power Exchange (7.x/8.x), Oracle 10g/11g, SQL, PL/SQL, UNIX Shell Scripting, Vertica 3.x/4.x, Teradata (BTEQ/Fastload/Multiload) and Business Objects.
• Strong Knowledge of Data Warehousing and Data modeling Concepts like Dimensional Modeling, Normalization, Star Schema and Snowflakes Schema.
• Strong experience in design (Logical & Physical) of databases, data warehouses and RDBMS development using Oracle 10g/11g, Teradata V2R5/V2R6, Vertica 3.0/4.0,DB2 and other database technologies.
• Extensively used Teradata RDBMS and Teradata Utility tools like Fast load, Multiload, BTEQ, Fast Export and Teradata SQL Assistant for developing and maintaining large - scale enterprise level Data Warehouse.
• Closely associated with the Data mining activities and supported Report development teams and created user reports using Business Objects 6.x/XI and Cognos Series 7.0.
• Database performance problem diagnosis and resolution for application scalability and throughput improvements. Performed role of a Business Analyst and translated business requirements into technical specifications.
• Strong leader with experience training developers and advising technical groups on ETL best practices.

TECHNICAL SKILLS

ETL: Informatica Power Center 6.x/7.x/8.6, Power Exchange 7.x/9.0, PL/SQL, SQL * Loader, Teradata Loading Utilities (Fastload/Multiload)

Database/RDBMS: Oracle 10g/11g, Teradata V2R5/V2R6/TD12, Vertica 3.0/4.0, DB2, SQL Server

Programming: C, COBOL, Java, Perl, SQL, PL/SQL, UNIX Shell Scripts

Operating Systems: Windows (2000, XP, NT), UNIX Sun Solaris 2.6/2.7, HP-UX 10.20

Tools: TOAD, ERWIN 3.0/4.0, Business Objects 6.x/XI, Cognos Series 7.0

PROFESSIONAL EXPERIENCE

Confidential, Houston,TX

Sr. ETL Developer/DWBI Module Lead

Responsibilities:

• Extensively worked with Informatica 8.6.x, Power Exchange 8.x, Oracle 10g/11g, PL/SQL Procedures, Unix Shell Scripts, Vertica 4.0, Business Objects Report development.
• Extensively worked with Power Exchange 8.x and mapped different sources from IBM Mainframe system like VSAM, COBOL and DB2 sources.
• Developed complex Mappings, Sessions and Workflows using Informatica Mapping Designer, Workflow Manager respectively.
• Developed the Informatica Code for TYPE II Dimensions and different types of load for Fact tables including incremental/snapshots.
• Design and developed PL/SQL procedures and functions to facilitate ETL jobs like creating/truncating partitions, Sequence, Triggers and procedures to perform specific ETL related tasks.
• Designed and coded ETL for many summarized/aggregated tables to consolidate data based on Banker’s reporting requirements.
• Created system for capturing, reporting, and correcting error data during night cycle and intra day loads.
• Created multiple UNIX shell scripts to conditionally validate, schedule and automate the ETL tasks/sessions and performed required actions on Oracle databases.
• Participated in Tool Selection Process for large banking data mart and did performance analysis for Vertica/Oracle systems.
• Participated in designing and developing of the ETL/BI architecture for business intelligence solution components including database design, ETL, report design and system integration.
• Provide on-call support to production system to resolve any issues.
• Issue Tracking and Defect Collection.
• Worked very closely with the Reporting team and was responsible for creating few Issuer reports using Business Objects xi.
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems of performance.
• Created and managed database objects like triggers, stored procedures, sequences and indexes containing PL/SQL in the database and monitored overall performance management.

Environment: Informatica PowerCenter 8.6, Power Exchange 8.x, Oracle 10g/11g,Vertica 3.0/4.0, Teradata TD12/13, UNIX, Fastload, Multiload, BTEQ, Oracle 10g/11g, SQL, PL/SQL, SQL * Loader, SQL *Plus, TOAD, Teradata SQL Assistant, Business Objects 6.x, Control M, Sun Solaris Unix.

Confidential, NY

Sr. ETL Developer/Application Architect

Responsibilities:

• Extensively worked with Informatica 7.x/8.6, Power Exchange 8.x, Oracle9i/10g, PL/SQL Procedures, Unix Shell Scripts, Business Objects Report development.
• Facilitates the gathering, consolidation and prioritization of client business requirements for various ETL Developments across the enterprise.
• Participated in designing and developing of the ETL/BI architecture for all business intelligence solution components including database design, ETL, report design and system integration.
• Developed complex Mappings, Sessions, and Workflows using Informatica Mapping Designer, Workflow Manager respectively.
• Extensively worked with Power Exchange 8.x and mapped different sources from IBM Mainframe system like VSAM, COBOL and DB2 sources.
• Designed ETL specification, PL/SQL Procedures and Unix Scripting to populate reporting data mart for Remaining Principal Balance RPB application associated with different Issuers, Investors and Custodians.
• Documented user requirements, translated requirements into system solutions, and developed implementation plan and schedule.
• Created multiple UNIX shell scripts to conditionally validate, schedule and automate the ETL tasks/sessions and performed required actions on Oracle databases.
• Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Issue Tracking and Defect Collection.
• Worked very closely with the Reporting team and was responsible for creating few Issuer reports using Business Objects xi.

Environment: Informatica Power Center 8.6 (Source Analyzer, Warehouse Designer, Mapplet Designer, Mapping Designer and Transformation developer), Power Exchange 8.x, Oracle 9i/10g, UNIX, Business Objects XI, VSAM, DB2,PL/SQL DEVELOPER, SQL, PL/SQL, SQL * Loader, TOAD, Erwin.

Confidential

Sr. Application Developer

Responsibilities:

• Extensively worked with Informatica 7.1.3, PL/SQL Procedures, Teradata Fastload, Multiload and BTEQ in UNIX environment.
• Developed complex Mappings, Sessions, and Workflows using Informatica Mapping Designer, Workflow Manager respectively.
• I was responsible for direct business interactions with client and understanding the requirements, analyzing, creating the Business requirements specifications and then translating it to offshore groups through Technical Specifications.
• Coordinated with Onsite/Offshore teams and successfully met the timelines.
• Responsible for Extraction, Transformation & Loading data from source to staging and staging to BIR Tables using Fast load and Multiload.
• Created UNIX scripts to conditionally validate the session and performed required actions.
• Requirement gathering and Business Analysis.
• Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.

Environment: Informatica PowerCenter 7.1.3 (Source Analyzer, Warehouse Designer, Mapplet Designer, Mapping Designer and Transformation developer), Teradata V2R5/V2R6, PL/SQL DEVELOPER, UNIX, Fastload, Multiload, BTEQ, Oracle 9i/10g, SQL, PL/SQL, SQL * Loader, SQL *Plus, TOAD, Teradata SQL Assistant, Business Objects 6.x, Control M, Sun Solaris Unix.

Confidential

Sr. ETL Developer

Responsibilities:

• Member of requirements definition and design team on long-term project to overhaul integrated pharmacy order processing system in order to implement new large-scale system (multi-tiered architecture, multiple integrated software applications), leading to opening of new pharmacy MSP-JV Order Management facility.
• Extracting data from different sources like Oracle, Flat files, DB2, External files and transformed the data based on Business requirements using Informatica Mapping Designer and loading into Oracle target database, by running the Informatica sessions/workflows in Workflow Manager.
• Involved in understanding the Requirements of the End Users/Business Analysts and Developed Strategies for ETL processes.
• Responsible for converting PL/SQL functions into Informatica Mappings and created the ETL automation script to run the Informatica workflows through UNIX box and worked with UNIX commands and wrote shell scripts.
• Created and Performed reviews on all ETL designs, mappings and test plans.
• Performance Tuning of Informatica mappings and sessions to improve the performance by session properties, by applying partitions at particular stages.
• Worked closely with Oracle DBA to analyze, design, document, develop and implement database procedures, packages, and triggers to streamline data collection and order processing, and to increase data integrity.
• Daily job Monitoring and troubleshoot problems by checking sessions and error logs.

Environment: Informatica Power Center 6.1/7.x, Oracle 9i, SQL, PL/SQL, Power Exchange, SQL * Loader, SQL Developer, SQL Server, Perl Scripts, UNIX Shell Scripts, DB2, TOAD, Sun Solaris 2.6. iGATE Global Solutions

Confidential

Informatica /Teradata Programmer

Responsibilities:

• Extensively worked with Informatica 7.1.3, Oracle9i/10g, PL/SQL Procedures, Teradata Fastload, Multiload and BTEQ in Unix environment.
• Developed complex Mappings, Sessions, and Workflows using Informatica Mapping Designer, Workflow Manager respectively.
• Used PL/SQL Procedures and Unix Scripting to populate reporting tables.
• Responsible for Extraction, Transformation & Loading data from source to staging and staging to BIR Tables using Fast load and Multiload.
• Created UNIX scripts to conditionally validate the session and performed required actions.
• Requirement gathering and Business Analysis.
• Configured sessions using Server manager to have multiple partitions on source data and to improve performance.
• Worked very closely with the Reporting team and was responsible for creating Reports using Business Objects.
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems of performance.
• Created Different Fastload, Multiload and BTEQ Scripts to facilitate the ETL Processes and presenting data reports to users.

Environment: Informatica PowerCenter 7.1.1 (Source Analyzer, Warehouse Designer, Mapplet Designer, Mapping Designer and Transformation developer), Teradata V2R5/V2R6, PL/SQL DEVELOPER, UNIX, Fastload, Multiload, BTEQ, Oracle 9i/10g, SQL, PL/SQL, SQL * Loader, SQL *Plus, TOAD, Teradata SQL Assistant, Business Objects 6.x, Control M, Sun Solaris Unix.

Confidential

ETL Developer

Responsibilities:

• Worked with Business analysts and DBAs for requirements analyzing & business analysis.
• Created complex Informatica Mappings using Designer and implemented slowly Changing Dimension Type 2 methodologies to populate the target tables.
• Coordinated with Application SMEs for performing day-to-day ETL Load monitoring, Data warehouse target schema design and maintenance.
• Responsible for the dimensional Data Modeling and populating the business rules using mappings into the repository for Meta Data management.
• Designed and developed Oracle PL/SQL and shell scripts, data import/export, data conversions and data cleansing.
• Daily load job monitoring using Informatica Job Monitor and handling the sessions/workflows failures.

Environment: Informatica 6.x, Oracle 9i, SQL, PL/SQL, SQL * Loader, SQL *Plus, Sun Solaris UNIX.