We provide IT Staff Augmentation Services!

Tech Lead Resume

Charlotte, NC

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

Tools: InformaticaPowerCenter9X

Confidential, Charlotte, NC

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

Tools: InformaticaPowerCenter8X,9X:

Hire Now