Informatica & Teradata Consultant Resume

PROFESSIONAL SUMMARY:

Around 13 years of experience in Information Technology in designing, developing, and implementation of Data Warehouse Applications using different environments. Core focus on Data Warehousing tools mainly Informatica, Teradata & Oracle. Competent in using BI tools like OBIEE and Tableau. Adept at extracting and combining data from multiple sources to come up with KPIs which have a direct impact on the bottom line of the organization. Coordinates with multiple stakeholders to drive excellence in every project & deliver outstanding results.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter, ODI

BI Tools: OBIEE, OBIA, Tableau, MS Excel

Databases: Oracle, Teradata, MS SQL Server

Languages: SQL, PL/SQL, Python, HTML

Operating Systems: Windows 2007/ XP/ 10, Linux

EXPERIENCE:

Confidential

Informatica & Teradata Consultant

Responsibilities:

Involved in full software development life - cycle, from requirements gathering & estimating to design & development
Interacted with Data Modelers and Business Analysts to understand the Business requirement and Develop the code.
Analyse the requirements to help come up with the right strategy to Extract and load into Data warehouse.
Implement slowly changing Dimension logic in the mapping to effectively handle change data capture.
Proficient in understanding Teradata EXPLAIN plans, Collect Stats and Indexes.
Extensively used Teradata utilities like FASTLOAD, MULTILOAD, TPUMP.
Extracted data from Flat files using UNIX shell scripts.
Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.
Extensively used workflow variables, mapping parameters and mapping variables.
Applied performance techniques like PDO, partitions and best practices for each transformation to avoid performance issues.
Involved in root causes analysis for recurring production failures and implemented permanent solutions to avoid failures.
Created AppWorx modules and scheduled to load the data on regular basis

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship