EXPERIENCE 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.
• Extensively worked on design & development of Informatica PowerCenter ETL code which includes mappings, mapplets, reusable transformations, shared objects, sessions and workflows.
• Confidential Certified Professional with Over 5 years of experience on Confidential development and OLAP operation with Confidential database.
• 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.
• Worked on data load performance tuning which includes eliminating source and target bottlenecks optimizing the mapping, eliminate session bottlenecks and optimize the server.
• Very good understanding of Confidential RDBMS architecture such as Shared Nothing, Nodes, AMPs, BYNET, Partitioning, Primary Indexes etc. Extensively used different features of Confidential such as BTEQ, Fast load, Multi load, Fast export, TPT, Confidential SQL Assistant
• 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 Oracle database which include creating and executing SQL queries, PLSQL procedures, Functions.
• Worked on Unix shell scripting and Used Tivoli, Crontab, Autosys, Control - M to schedule Jobs
• End to end experience in designing and deploying data visualizations using 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), Confidential, Oracle, Tableau, Confidential Utilities, GCFR, MySQL, Autosys, Control-M, TOAD, SQL Developer, WinSCP, JIRA, Cascade, Test director, Ultraedit, Edit Plus, Remedy, C, C++, HTML.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr ETL Developer

Responsibilities:

• Analyzing the requirements and making functional specification by discussing with business user groups and translate the Business Requirements and documented source-to-target mappings and ETL specifications
• Created complete end to end (Stage,ODS,DWH,Mart) tables.
• Created multiple indexes, constrains based on business rules and data.
• Worked with Source Analyzer, Warehouse Designer, Transformation designer, mapping designer and Workflow Manager to develop new Mappings & implement data warehouse.
• Used Confidential utilities like BTEQ, MultiLoad, Tpump, and Fast Load,TPT to load data into Confidential data systems.
• Involved in Estimations and Planning of the Project activities
• Coordinated between client and Informatica ETL developers.
• Created Parameter files to pass database connections, parameter entries for source and target.
• Prepared reusable ETL code and Unix shell scripts.
• Used workflow tasks like Session, Email, and Command etc.
• Created slowly changing dimensions & Fact tables to meet the business requirements
• Used the debugger in Informatica to test the mapping and fix the mappings.
• Worked on Push Down Optimization to optimize loads.
• Created BTEQ scripts, views to build the semantic layer.
• Identified the bottlenecks and tuned the performance of Informatica ETL code .
• Tuned various queries by COLLECTING STATISTICS on columns in the WHERE and JOIN expressions.
• Scheduled jobs for batch processing using Crontab
• Created SQL Queries to validate the data in both source and target databases.
• Analyzed the data issues and proposed the solutions to fix
• Reviewed Unit testing and done the Integration testing.
• Worked with cross functional teams to resolve the issues.
• Closely worked with end users on User Acceptance Testing.
• Involved in code migration to live environment and Created deployment documents.

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
• Developing Informatica mappings and workflows for extracts and feeds. Data is extracted through mappings from different Sources like Confidential, Flate Files.
• Involved in developing Informatica jobs as per Confidential GCFR (Global Control Framework) Architecture.
• Created TPT and ODBC Connections in Informatica.
• Used Confidential utilities like BTEQ, MultiLoad, Tpump, and Fast Load.
• Prepared the guide for ETL deployment in QA and Production environment
• Implemented Target Load Plan and Pre Session and Post Session Scripts
• Developed Tableau reports & dashboards using Tableau desktop.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows
• 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 done the Integration testing.
• Reviewed Low Level design documents.
• Involved in code migration to live environment and Created deployment documents.

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/ Confidential 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 Confidential 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 Confidential TPT and ODBC Connections.
• Used Confidential utilities like MultiLoad, Tpump, and Fast Load to load data into Confidential 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 Confidential .
• Knowledge transfer to the PS team.
• Created various UNIX shell scripts to automate the jobs.
• Performed Unit testing and Integration testing.

Environment: Confidential 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 8.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 Unix, Toad, JIRA, HPQC