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.
• Experience on design & development of Informatica PowerCenter ETL code which includes mappings, mapplets, reusable transformations, shared objects, sessions and workflows.
• Extensive experience in creation of ETL mappings and Transformation to reflect business rules using Informatica Power Center to move data from multiple sources into target area.
• Teradata Certified Professional with Over 5 years of experience on Teradata development and OLAP operation with Teradata database.
• End to end experience in designing and deploying data visualizations using Tableau
• 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
• Worked on data load performance tuning which includes eliminating source and target bottlenecks optimizing the mapping, eliminate session bottlenecks and optimize the server.
• Experience in Relational Data Modeling and Dimensional Data Modeling, Star Schema Modeling, Physical and Logical Data Modeling, Erwin 4.0/3.x, Oracle Designer
• Worked on Unix shell scripting and Used Tivoli, Crontab, Autosys, Control - M to schedule Jobs
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables with tableau.
• Experience in multiple business domains (Telecom, Health care, Financial, Retail).

TECHNICAL SKILLS

Operating Systems: Windows, UNIX

Software Products/Tools: Informatica PowerCenter(8.x,9.x), Teradata, Oracle, Tableau, Teradata Utilities, GCFR, Informatica data quality,Business Objects, SQL Server, MySQL, Autosys, Control-M, TOAD, SQL Developer, WinSCP, JIRA, Cascade, Test director, Ultraedit, Edit Plus, Remedy, CASD, C, C++, HTML.

PROFESSIONAL EXPERIENCE

Confidential, Chicago IL

Sr ETL Developer, Analyst

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
• Worked on Push Down Optimization to optimize Oracle loads.
• Developed the complicated ETL code using advanced concepts.
• 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.
• Prepared reusable ETL code and Unix scripts.
• 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
• Created BTEQ scripts, views to build the semantic layer.
• Created dashboards in tableau using the various sources of data from Excel sheets, Teradata.
• Created and Published Tableau Dashboards into Tableau Server.
• Identified the bottlenecks and done the performance tuning.
• Scheduled jobs for batch processing using Crontab
• Analyzed the data issues and proposed the solutions to fix
• Reviewed Unit testing.
• Reviewed Low Level design documents.
• Code migration to live environment.

Environment: Erwin, Informatica PowerCenter 9.x, Teradata14, BTEQ, FastLoadFastExport, Multiload, Unix, Tableau, Tivoli, WinSCP, Remedy

Confidential

Sr ETL Developer

Responsibilities:

• Involved in source system analysis and understanding the business requirement.
• Involved in complete SDLC (System Development Life Cycle).
• Analyzed the Business requirements to be converted into the ETL loads from Source to Stage layer, core tables and then to Semantic Layer
• 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.
• Created BTEQ / Fast load scripts, Created TPT and ODBC Connections in Informatica.
• Involved in Operational Loading.
• Prepared the guide for ETL deployment in QA and Production environment
• Developed Tableau reports & dashboards using Tableau desktop.
• Preparation of Production support document.
• Created Cascade scheduler to automate the jobs.
• Analyzed the data issues and proposed the solutions to fix
• Reviewed Unit testing.
• Reviewed Low Level design documents.
• Code migration to live environment.

Environment: Erwin, Informatica PowerCenter 9.x, Teradata13, BTEQ, FastLoadFastExport, Multiload, Unix, Tableau, Control-M, WinSCP, HPQC

Confidential

Sr 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, Informatica PowerCenter 9.x, Oracle10g, SQL Developer, BTEQ, FastLoad, FastExport, Multiload, Unix, Control-M, WinSCP, HPQC

Confidential

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 DeveloperUnix, 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