SUMMARY:

• 6 years of professional experience in analysis, design, development and implementation of software applications mainly in the field of Data warehousing, Databases on Linux/Unix and Windows
• 4 years of ETL experience using Informatica 9.5/8.6/7.1
• Expertise in Informatica ETL tool to develop, test and tune mappings, sessions and workflows.
• Designing and developing Informatica mappings including slowly changing dimensions (SCD) type 1 and 2.
• Excellent analytical and problem - solving skills and ease working within a team and independently.
• Strong experience in understanding Dimensional Modeling like star and snowflake schema and identifying the Facts and Dimensions.
• Experience in working with Power Exchange to process the Mainframe VSAM files.
• Experience writing advanced SQL queries, PL/SQL Stored procedures and Functions.
• Knowledge of Bill Inmon and Ralph Kimball methodologies.
• Helped mentor other junior team members to analyze and resolve problems.

TECHNICAL SKILLS:

Tools: ETL Tools Informatica 9.5/8.6/7.1, Informatica Developer (IDQ), Power Exchange, SQL*Plus, SQL Loader, TOAD, Business Objects, Teradata SQL Assistant, Humming Bird, Microsoft management studio, SSRS, SSIS.

Database: Oracle10g / 9i, Teradata12, MS SQL Server 2008/2005, DB2 8, Postgres

Operating Systems: UNIX, Linux, Windows

SQL, PL/SQL, T: SQL, UNIX/Linux Shell Scripting

PROFESSIONAL EXPERIENCE:

Confidential, Allen TX

ETL Developer

Responsibilities:

• Worked on various projects like data replication process, FCC Compliance & Salesforce enhancement projects etc.
• Responsible for user requirement gathering, data analysis, solving defects and designing mappings, mapplets, jobs scheduling configuration using Autosys.
• Used Informatica Power center tools like Source analyzer, Target designer, Transformation designer, mapplet designer, workflow manager and workflow monitor.
• Created and developed mappings using Expression, Router, Joiner, Aggregator, Lookup, Update Strategy, Sorter and other transformations.
• Implemented ETL workflows to source data from different sources like AS400 tables, MS-SQL Server, Oracle, DB2, flat files, Teradata and Salesforce tables.
• Involved in designing and development of pre and post session routines and batch execution routines.
• Documented various mappings and transformations used in project.
• Experienced in implementing ETL best practices, performance tuning and optimization techniques for various Informatica components.
• Responsible for Unit Testing and providing post deployment production support.
• Wrote UNIX scripts to drop Teradata error tables, warm start, cold start, recover, stop and abort workflows.
• Used ‘Address Doctor’ to correct address anomalies and get census information, geo-coding and related addresses.
• Experience in working with Informatica developer (IDQ) tool (Physical data objects, transformations like Address validator, Expression, Joiner, Filter transformations) for developing mappings and profiling.
• Prepare/maintain documentation on all aspects of ETL processes to support knowledge transfer to other team members.
• Used Teradata utility like FLOAD and Teradata Parallel Transporter (TPT).
• Coded Teradata Store procedures and Cursors.

Environment: Power Center 9.5, SQL Server, Oracle 10g, Teradata 12, UNIX, Shell Scripts, Teradata SQL Assistant, Power exchange, AS400, IDQ 9.5, Informatica developer 9.5 (IDQ), Salesforce.

Confidential, Grapevine TX

ETL Developer

Responsibilities:

• Responsible for user requirement gathering, designing and developing Data marts in business Intelligence environment.
• Designed SSIS Packages to extract data from various data sources such as Oracle Database, Excel spreadsheets and flat files into SQL Server 2008 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge & union all
• Scheduled and maintained daily and weekly loads of data by creating the corresponding job tasks.
• Responsible for creating Stored Procedures, tables, and views and other SQL joins
• Implemented the Package configuration using XML files.
• Responsible for Unit testing of packages.

Environment: SQL Server 2008 R2 integration service, Postgres, Windows 7.

Confidential, Plano TX

ETL Developer

Responsibilities:

• Responsible for user requirement gathering, data analysis and designing mappings and mapplets using Informatica Source analyzer, Warehouse designer, Transformation designer and Mapplet designer
• Created and developed numerous mappings using Expression, Router, Joiner, Lookup, Update Strategy and other transformations.
• Extensively involved in working on different active and passive transformations.
• Extraction, transformation and loading of data were carried out from different sources like Flat files, VSAM File, MS-SQL Server and Oracle.
• Created data maps (VSAM source) using power exchange.
• Involved in designing and development of pre and post session routines and batch execution routines.
• Duties involved in documentation of mappings and transformations.
• Involved in the migration of code from development to QA.

Environment: Power Center 8.6, SQL Server, Oracle 10g, PL/SQL, TOAD, IBM DB2, Teradata 12, UNIX, Shell Scripts, Teradata SQL Assistant, Power exchange.

Wells Fargo

ETL Developer

Responsibilities:

• Involved in gathering of requirements from business analysts for designing and development of the system.
• Developing Informatica mappings and shell scripts for loading data.
• Actively participated in a team in the logical and physical design of the data warehouse.
• Developed the Informatica mappings using various transformations, Sessions and workflows. SQL Server was the target database, Source database is a combination of Flat files, Oracle tables, SQL Server, CSV files etc.
• Responsible for working closely with the Informatica administrator to migrate Source and Target definitions, Mappings, Workflows, and Flat Files from development environment to the production environment.
• Used different tasks like Email, Command task.
• Worked with the Informatica Administrator to migrate the mappings, sessions, source/target definitions from the development repository to the production environment.
• Performance tuning of the Informatica mapping, sessions and workflows. Created the reusable transformations for better performance.

Environment: Informatica Power Center 8.6, Windows NT, Shell Scripts, Oracle 10.2, PL/SQL, SQL Server, LSF, DB2, TOAD, FTP, SQL*PLUS.

Confidential

Junior SQL Server Developer

Responsibilities:

• Involved in gathering user requirements.
• Created Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic.
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Managing of databases objects like Tables, views, indexes etc.
• Used BCP utility to publish table output to text files.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Developed scripts for maintaining administration tasks.
• Developed DTS Packages to transfer the data between SQL server database and files.
• Creation and management of database maintenance plan for various database consistency checks.

Environment: Windows 2000, SQL Server7.0/2000, VB 6.0, Enterprise Manager, SQL Profiler, DTS, T-SQL, BCP, Replication.