SUMMARY

• Having 9+ Years of experience in Data Warehouse and Business Intelligence systems Design, development and maintenance which include requirements gathering, Business Analysis, system architecture, preparing estimation, design, development and testing of ETL, data migration, data analysis, data profiling, data issues analysis and fix, job failures root cause analysis and fix, jobs scheduling, Performance tuning of Data Warehouse and ETL data load, Documentation of requirements, design, development & testing phases, team management, code review, analysis of existing system, impact analysis, integration testing, defects analysis and fix.
• Extensive experience on design & development of Informatica PowerCenter ETL code which includes mappings, mapplets, reusable transformations, shared objects, sessions and workflow.
• Teradata Certified Professional with Over 5 years of experience on Teradata development and OLAP operation with Teradata database 12,13,14.
• Very good understanding of Teradata RDBMS architecture such as Shared Nothing, Nodes, AMPs, BYNET, Partitioning, Primary Indexes etc. Extensively used different features of Teradata such as BTEQ, Fast load, Multi load, Fast export, TPT, Teradata SQL Assistant
• Experience in Relational Data Modeling and Dimensional Data Modeling, Star Schema Modeling, Physical and Logical Data Modeling, FSLDM.
• Worked on data load performance tuning which includes eliminating source and target bottlenecks optimizing the mapping, eliminate session bottlenecks and optimize the server.
• End to end experience in designing and deploying data visualizations using Tableau
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables with tableau.
• Worked on Unix shell scripting and Used Tivoli, Crontab, Autosys, Control - M to schedule Jobs
• Worked on Stored Procedures, Macros and Triggers.
• Experience in multiple business domains (Telecom, Health care, Financial, Retail).

TECHNICAL SKILLS

Operating Systems: Windows, UNIX

Software Products/Tools: Teradata, SQL Assistant, Teradata Utilities(BTEQ, FastLoadFastExport, Multiload), Informatica PowerCenter, Oracle, Tableau, GCFR, SQL Server, MySQL, Autosys, Control-M, Tivoli, TOAD, SQL Developer, WinSCP, JIRA, Cascade, Test director, Ultraedit, Edit Plus, Remedy, C, C++, HTML.

PROFESSIONAL EXPERIENCE

Confidential, Chicago IL

Sr. Teradata ETL Developer

Responsibilities:

• Researched Sources and identified necessary Business Components for Analysis.
• Responsible for documenting the EDW Semantic system analysis in the form of HLD (High Level Design) document.
• Gathered the required information from the users.
• Analyzed the Business requirements to be converted into the ETL loads from EDW layer to Semantic Layer
• Used Teradata utilities like MultiLoad, Tpump, and Fast Load to load data into Teradata data warehouse from source systems.
• Created tables, views in Teradata, according to the requirements.
• Created proper PI taking into consideration of both planned access of data and even distribution of data across all the available AMPS.
• Assisted developers with Teradata load utilities and SQL.
• Involved in Estimations and Planning of the Project activities
• Tuned various queries by COLLECTING STATISTICS on columns in the WHERE and JOIN expressions.
• Performance tuning for Teradata SQL statements using Teradata EXPLAIN
• Created BTEQ scripts, views to build the semantic layer.
• Identified the bottlenecks and done the performance tuning of ETL code.
• Scheduled jobs for batch processing using Tivoli
• Analyzed the data issues and proposed the solutions to fix.
• Created dashboards in tableau using the various sources of data from Excel sheets, Teradata.
• Created and Published Tableau Dashboards into Tableau Server.
• Reviewed Unit testing.
• Code migration to live environment.

Environment: Teradata 14, Informatica PowerCenter 9.x BTEQ, FastLoad, FastExportMultiload, TPT, Unix, Tableau desktop 9.x, Tableau server, Tivoli, WinSCP, Remedy

Confidential

Sr.Teradata ETL Developer

Responsibilities:

• Involved in source system analysis and understanding the business requirement.
• Involved in complete SDLC (System Development Life Cycle).
• Involved in Estimations and Planning of the Project activities
• Involved in creation of high level source to target mapping document in the form of SMX
• Involved in developing Informatica jobs as per Teradata GCFR (Global Control Framework) Architecture.
• Used Teradata utilities like MultiLoad, Tpump, and Fast Load to load data into Teradata data warehouse from source systems.
• Created Logical and Physical Data Models
• Involved in Creating UNIX Scripts for triggering the Stored Procedures and Macro.
• Created TPT and ODBC Connections in Informatica.
• Involved in Operational Loading.
• Prepared the guide for ETL deployment in QA and Production environment
• Involved in deployment of objects.
• Preparation of Production support document.
• Developed Tableau reports & dashboards using Tableau desktop.
• Created Cascade scheduler to automate the jobs.
• Analyzed the data issues and proposed the solutions to fix
• Experience in creating data visualizations using Tableau Desktops and regularly publishing and presenting dashboards into the server.
• Reviewed Unit testing.
• Reviewed Low Level design documents.
• Code migration to live environment.

Environment: Teradata 13, Informatica PowerCenter 9.x BTEQ, FastLoad, FastExport, Multiload, TPT, Unix, Tableau desktop 8.x, Tableau server, Control-M, WinSCP, HPQC

Confidential

Terdadata ETL Developer

Responsibilities:

• Worked as and Understanding requirements, design of solution and preparation of Design documents.
• Interacted with people from various teams in the Project like Oracle/Teradata DBAs', Maestro Schedulers,Spec. Creators, Reporting, Unix etc. to aid in the smooth functioning of the Project flow.
• Conversion of all the Oracle Functions and Procedures to Teradata BTEQ/SQL scripts.
• Migration of Informatica code from Informatica 8.1 to version 9.1.
• Migration of Informatica Target connections from Oracle ODBC connections to Teradata TPT and ODBC Connections.
• Used Teradata utilities like MultiLoad, Tpump, and Fast Load to load data into Teradata data warehouse from source systems.
• Prepared the Scheduling information for information based and analyzed the dependencies between informatica objects
• Migration of Oracle target tables to Teradata.
• Knowledge transfer to the PS team.
• Created various UNIX shell scripts to automate the jobs.
• Performed Unit testing and Integration testing.

Environment: Teradata 12, Erwin, Informatica PowerCenter 9.x, Oracle10g, SQL Developer, BTEQ, FastLoad, FastExport, Multiload, Unix, Control-M, WinSCP, HPQC

Confidential

Sr ETL Developer

Responsibilities:

• Gathered Business Requirements by interacting with client.
• Analyzed Business Requirements.
• Prepared Requirements Specification documents Development of various ETL mappings using Informatica.
• Prepared best practices, naming conventions and design document templates.
• Performed Unit testing and Integration testing.
• Created many reusable transformations and maplets to optimize the work.
• Created various tasks, workflows and worklets.
• Developed the complicated ETL code using advanced concepts.
• Worked for performance improvement.
• Created Batch Tracking
• Involved in unit testing, system testing and integrated testing.
• Generate weekly, monthly reports for internal and external database and system audit.
• Given knowledge transition to Production support team.
• Closely worked with end users on User Acceptance Testing.

Environment: Informatica PowerCenter 9.x, Oracle 10g, SQL Developer, TeradataUnix, Toad, WinSCP, HPQC

Confidential

ETL Developer

Responsibilities:

• Understanding requirements, design of solution and preparation of Design documents.
• Development of various ETL mappings using Informatica.
• Created many reusable transformations and maplets to optimize the work.
• Created various tasks, workflows and worklets.
• Tuned performance of sources and targets.
• Created various UNIX shell scripts to automate the jobs.
• Performed Unit testing and Integration testing.

Environment: Informatica PowerCenter 8.x, Oracle 9i, SQL DeveloperUnix, Toad, JIRA, HPQC

Confidential

ETL Developer

Responsibilities:

• Designed mapping documents, which include details of field-to-field mapping between sources and target, Business rules, Processing flow and details of sessions, pre-dependencies and post-dependencies.
• Created various mappings with Source Qualifier, Expression, Aggregator, different types of look-ups, Joiner, Sorter, Router, Filter, Update Strategy, Sequence Generator, Normalizer …etc transformations to meet the business requirement.
• Created various tasks, workflows and work lets.
• Performed Unit & Integration testing.

Environment: Informatica PowerCenter 7.x, Oracle 9i, SQL Developer