CAREER OBJECTIVE:

A challenging position that will enable me to exhibit my professional competency and help me to learn, grow and reach great heights in my field of experience.

EXPERIENCE SUMMARY:

• 8+ years of experience in architecture, development and support of ETL, OLTP and OLAP solutions the IT industry.
• Strong Knowledge of Dimensional Modelling, DW architecture, ETL Frameworks, Design and Development using Informatica.
• Proficient with Informatica PowerCenter 8x, 9x,SSIS, SQL server, Oracle PLSQL, Confidential, Siebel CRM and DAC.
• Expertise in analysing, designing, developing using Microsoft SQL Server Integration services(SSIS).
• Expertise in writing T - SQL /SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
• Completed multiple new data Integration projects successfully.
• Lead a team of ETL Developers to deliver many projects successfully in Agile methodology.
• Designed and Implemented SCD’s, Hierarchical tables, and Complex mapping requirements.
• Have worked in ETL Development, Production Support, Performance Tuning, and Administration.
• Proficient in Oracle, Microsoft SQL Server and relational databases and worked on development of procedures, packages and performance tuning of SQL Queries.
• Experience in Data Quality Implementation using Informatica and Confidential .
• Experience in Production Support of Daily/Weekly ETL jobs from OLTP to OLAP.
• Experience in Unit testing and quality assurance of deliverables
• Experience in managing Informatica administrator for PowerCenter.
• Import /Export Repository and Creating and Troubleshooting Repository Service and Integration Service.
• Configuring and setting up DAC (Data Warehouse Administration Console).
• Strong Inter Personal Communication Skills.

TECHNICAL SKILLS:

Data Integration: Informatica Powercenter 8,9X,SSIS

Relational Databases: Oracle 11g,12C, SQL Server 2008

Programming Languages: C, C++, Java

Web Development: HTML, PHP

Data Analytics: Oracle OBIEE, DAC, Siebel CRM

Operating Systems: Windows 2008, XP,7,8, Unix

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Tech Lead

Responsibilities:

• Lead a team of experienced ETL developers in offshore and guided them in developing and integrating many SOR’s into Confidential .
• Collaboration with the client, proposing technical solutions for data integration requirements, code development and Testing.
• Offshore - On site co-ordination.
• Performance testing and production deployment process.
• Direct collaboration with the client, data architects understanding requirements, analysing system limitations, proposing technical solutions, code development and testing.
• Development of Informatica ETL mappings, Autosys Batch jobs, SQL Procedures and functions according to the Requirement.
• Coordinating offshore team and guiding them through the development of modules according to scheduled releases.
• Deployment and pre/post deployment activities of code and objects into production as per project schedule.

Solution Environment: Informatica PowerCenter 9, Autosys, Unix, Oracle 11 G, SQL Server

Confidential, Charlotte, NC, USA

Developer

Responsibilities:

• Collaboration with the client, proposing technical solutions for Data Quality requirements, code development and Testing.
• Offshore - On site co-ordination.
• Development of Informatica ETL mappings, Autosys Batch jobs,SQL Procedures and functions according to the Requirement.
• Coordinating offshore team and guiding them through the development of modules according to scheduled releases.
• Deployment and pre/post deployment activities of code and objects into production as per project schedule.

Solution Environment: Informatica PowerCenter 9, Autosys, Unix, Oracle 11 G,SQL Server

Confidential

Developer

Responsibilities:

• Module leader for Informatica PowerCenter.
• Collaboration with the client proposing technical solutions, code development and production Support.
• Bug fixing, Error detection, Testing and Performance improvement of ETL Jobs.
• Analysing the root cause for production issues and solving before start of business.
• Developing and maintaining Siebel EIM, Batch jobs.
• Offshore - On site co-ordination.
• Development of Informatica ETL mappings and SSIS ETL packages, Siebel EIM (Enterprise Integration Management) jobs and SQL server/Autosys Batch jobs, T SQL Procedures and user defined functions according to the Requirement.
• Coordinating End to End testing of the developed code with testing team and with upstream and downstream applications.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
• Developed, deployed, and monitored SSIS Packages.
• Deployment and pre/post deployment activities of code and objects into production as per project schedule.
• Production Support and monitoring of Daily/Weekly Jobs.
• Performance Tuning of Existing ETL Jobs
• Configured Oracle DAC from the beginning for Siebel.
• Migrated from Siebel Analytics DAC to Oracle DAC.
• Migrated from Informatica PowerCenter 8.1.1 to 9.0.1
• Performed Informatica PowerCenter administration tasks of the lower lane environments.

Solution Environment: Informatica PowerCenter 9, Autosys, Siebel EIM, SQL Server 2008, Windows XP, Windows server 2003, Windows Server 2008