Technology Lead Resume

SUMMARY

I have more than 10 years of experience in Data warehousing, Building Informatica mappings, Designing workflow logic, performance tuning of long running and inefficient informatica jobs, fine tuning the long running SQL queries, preparation of design documents and Code level design documents and after release maintenance and support.
Performed extensive data analysis using tools like Informatica developer and created dashboards using Qlikview.
Developed a reusable solution to track ticket surveys and generate analytics out of it.
Experience in working on End - To-End implementation of data warehouse and understanding of Data Warehouse Concepts, ETL and Star schema
Experience in all phases of SDLC life cycle involving Requirement Analysis, Design, Coding, Testing, Deployment and Production Support.
Extensive knowledge of multiple industry domains like manufacturing, retail, travel and logistics and Healthcare.
Hands on Experience in preparing High Level Design (HLD), Detailed Design (DLD), ETL Mapping Specification and Unit Test Documentation in the Design and development phases.
Experience in Informatica performance tuning/Partitions and identifying the bottle necks in sources, mappings, targets and sessions.
Worked on a variety of data sources including but not limited to XML files and EBCDIC files
Worked on datwarehouse platforms based a multitude of databases like, Oracle, Exadata, Greenplum and Teradata.
Solid work experience on scheduling tools like Tidal and Control-M
Developed a reusable component in BO to track and calculate the usage metrics of a Data warehouse
Excellent Interpersonal and Communication skills, organizational skills, ability to handle multiple tasks and work well in a team environment.

TECHNICAL SKILLS

Operating System: Windows

ETL Tools: Informatica Powercenter

Analytics Tools: Qlikview

OLAP Tools: Cognos Power Play cubes

Reporting Tools: Cognos 10, Business Objects 6.5 Dashboard

Database: Oracle 9i, Greenplum, Teradata

Programming Languages: C, SQL, PLSQL

PROFESSIONAL EXPERIENCE

Technology Lead

Confidential

Responsibilities:

Work as a ETL Lead as part of one of the Agile teams.
Interacting with Product owner and team members to get and review the requirements.
Interacting with the Business Analysts and the Data Modeler to review the data model, HLD and LLD.
Profiling of source data using Informatica developer tools.
Designing the data extraction architecture keeping I view the data complexities and the user requirements.
Participating in the planned deployment of code to the production environment
Monitoring the operations activities.
On call support person on a rotating monthly basis.
Helping in debugging and resolution of any productions issues.
Performance tuning of long running or troublesome informatica jobs.
Preparing support and operations related documents like migration documents, service guide and support manuals.

Lead Consultant

Confidentia

Responsibilities:

Work as a Subject Matter Expert (SME) for the entire subject area.
Interacting with Product lead and development teams to review the requirements.
Interacting with the Dev team to review the data model, HLD and LLD.
Participating in the planned deployment of code to the production environment
Monitoring the operations activities.
Helping in debugging and resolution of any productions issues.
Performance tuning of long running or troublesome informatica jobs.
Preparing support and operations related documents like migration documents, service guide and support manuals.

Confidential

Associate

Responsibilities:

Interacting with Product lead and Business Analyst and getting the requirements.
Designing and Creating Informatica mappings.
Creating and Reviewing documents
Mapping Design Document
Unit Test Plan Document
Help document to support team (which includes common issues and resolutions for the same)

Confidential

Associate

Responsibilities:

Interacting with Product lead and Business Analyst and getting the requirements.
Designing and Creating Informatica mappings and cognos Reports.
Creating and Reviewing documents
Mapping Design Document
Report Design Document
Unit Test Plan Document
Help document to support team (which includes common issues and resolutions for the same)

Confidential

Associate

Responsibilities:

Analysis of the existing ETL architecture and making necessary design changes to configure the ETL load to pull data from the new OOD instance.
Doing extensive load testing and data testing to ensure that the new instance is up and running properly.
Completing the Month end book closing process from the new instance to prove data accuracy of the new system.
Analysis of the Mapping specifications provided by the clients in the form of mapping design documents and Business requirement document.
Design and Develop Informatica mappings.
Unit testing after the development phase
System integration testing during the test phase in QA

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship