SUMMARY

• Over 10 years’ experience in IT and 8+ years of Data Warehouse experience.
• Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer, Teradata SQL Assistant.
• Expertise in working with various transformations using Aggregator, Look Up, Update Strategy, Joiner, Filter, Sequence Generator, Normalizer, Sorter, Router transformations in Informatica PowerCenter Designer.
• Extensively used tools of MLoad, BTEQ, FastExport and FastLoad for transforming and maintaining data warehouse.
• Proficient in performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN, Collect Statistics.
• Effectively worked with Teradata TPT Connection Objects, View Point
• Strong expertise in physical modeling with knowledge to use Primary, Secondary, PPI and join Index.
• Strong experience in allocating work, guiding and leading team of developers in on site offshore model.
• Expertise in building Enterprise Data Warehouse from wide variety of source systems and Data Marts sourced from EDW.
• Good knowledge on Agile Methodology and the scrum process.
• Expertise in Writing and Debugging Shell Scripts.
• Expertise in working with various operational sources like Oracle and SQL Sever.
• Strong working experience in planning and carrying Data Warehousing, MPP and Large - Scale Database Management.
• Through knowledge in Teradata and Oracle RDBMS Architecture.
• Experienced in troubleshooting Teradata scripts, fixing bugs and addressing production issues and performance tuning.
• Experienced in tuning Teradata SQL using Temporary tables and indexes.
• Extensive experience in loading high volume data, requirements gathering, analysis, design, development, test and implementation.
• Exceptional verbal and written communication skills, excellent team player.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.5/8.6Database: TERADATA 14,13,12, Oracle

UTILITIES: BTEQ, MLOAD, FLOAD, FEXP

Modeling Tools: ER/Studio

Languages: C, SHELL SCRIPTING

Operating Systems: Windows NT/2000/XP/2007, UNIX, LINUX

Query Tools: BTEQ, SQL Assistant, SQL Developer

PROFESSIONAL EXPERIENCE

Sr. ETL Developer

Confidential, Orlando, FL

Responsibilities:

• Extracted data from XML files using Informatica and loaded it to Stage tables.
• Created BTEQ Scripts which contains SQL Transformation logic.
• Performed FLOAD Operation on Stage tables using TPT Connection Object.
• Performed MLOAD Operation on Dimensional and FACT Tables using TPT Connection object.
• Created numerous Mappings and using Transformations like XML Parser, Lookups, Expression, Sequence generator, Sorter, Joiner and Update Strategy.
• Implemented slowly changing dimensions type I and type II using date.
• Worked effectively with volatile and Global Temporary tables.
• Used Parameter files to define values for parameter and variable used in the mappings and sessions.
• Created session in Workflow manager and worked effectively with Command Tasks.
• Unit testing self and other mappings before deploying the code for different environments.
• Handled UNIX operating system tasks by generating Pre and Post-Session UNIX Shell Scripts.
• Called stored procedures in PL/SQL for certain key business requirements.
• Effectively utilized PRIMARY INDEX, Secondary Index and PPI.
• Involved in Unit and Integration Testing of the Data Warehouse.
• Improved performance of SQL Statements using Temporary tables.
• Be an active participant in both technology and business initiatives.

Sr. ETL Developer

Confidential, Minneapolis, MN

Responsibilities:

• Prepared Technical design documents based on Functional design documents.
• Populate or refresh Teradata tables using Fast load, Multi load & Fast export utilities for user acceptance.
• Testing and loading history data into Teradata.
• Implemented slowly changing dimensions Type 2 using date.
• Created Views as part of developing semantic layer.
• Tuned existing queries by creating join indexes and worked on query optimization.
• Written BTEQ Scripts which contains complex transformational logic.
• Worked with Volatile tables and global temporary tables to debug issues.
• Worked on production issues and as well as change requests.
• Prepared project related and process related functional documents.
• Involved in Scrum meeting on day to day activities and Task.
• Performed unit testing and supported deployment activities.

Software Developer

Confidential

Responsibilities:

• Worked on Teradata stored procedures.
• Created views using SQL which contains transformational business logic.
• Worked on production issues and fixes.
• Worked on change requests and provided estimations to clients.
• Involved in daily status calls to discuss issues with users, modellers.
• Wrote SMX document based HLM design documents.
• Handled team of 3 members and acted as supervisor/mentor.
• Converted 3NF core tables to Dimensions and facts while building semantic layer.

Software Developer

Confidential

Responsibilities:

• Responsible for developing, supporting and maintaining the ETL (Extract, Transform and Load) processes.
• Designed and developed ETL Mappings using Informatica to extract data from flat files and Oracle.
• Extensively worked on different transformations like Source Qualifier, Router, Normalizor, Expression, Lookup, update strategy and Joiner.
• Developed Teradata Stored Procedures.
• Developed session tasks and email tasks.
• Involved in Unit and Integration Testing of the Data Warehouse.
• Wrote documentation to describe program development, logic, coding, testing, changes and corrections.

Software Developer

Confidential

Responsibilities:

• Created BTEQ Scripts.
• Worked with temporary tables like Global temporary table and Volatile table.
• Worked with all major indexes like Secondary index, PPI.
• Worked with FLOAD to load data for testing purposes.
• Worked with FEXP to export data from different environments.
• Created shell scripts.
• Created process related documents.
• Did Unit testing before migrating the code to different environments.

Tester

Confidential

Responsibilities:

• Involved in writing ETL Queries to validate the as per mapping specifications.
• Validation of star schema using SQL.
• Validation of Record count between Source and Confidential .
• Involved in writing Regression Queries.
• Involved in writing smoke test cases, PK test cases and Business Test cases.
• Involved in scenario identification and data identification.
• Involved in bench marking of policies from production.
• Involved in client status calls and defects logging in Quality center.

Software Developer

Confidential

Responsibilities:

• Involved in Monitoring Informatica jobs as a production support.
• Unloading the data into a file from table using Fast Export.
• Involved in running jobs using scheduling tool $U.
• Involved in writing the SQL queries using Teradata SQL assistant.
• Involved in unit testing and Preparing test cases document.