Programmer Analyst Resume

SUMMARY

13 years of experience in Development in Data warehousing using informatica power center, Informatica IDQ, Oracle and Teradata and Big data technologies Hadoop and Hive.
Currently working as a Tech Lead.
Has good amount of experience in Coding on Informatica, IBM DataStage, Oracle PL/SQL and Teradata, batch scripting and unix shell scripting.
Strong skills in Data Analysis, Data Requirement Analysis, Data gaps, root cause analysis and Data Mapping for ETL processes
In - depth knowledge in the Teradata cost-based query optimizer, identifying potential bottle necks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI/USI/NUSI/JI etc.) etc.
Experienced in working with design and architecting projects for Data warehouse, executed complete re-design of architecture and stabilized the architecture.
Expertise in handling complex requirements, build design and develop the ETLs for it
Experience in interacting with client directly for specific requirements to understand the requirement exactly and providing solution with first time right approach
Good skill in identifying root cause for issues in production and quickly provide fixes
Good working and practical knowledge in all aspects of SDLC like requirement analysis, design, development, testing, implementation and maintenance of Projects.
Exposure with Teradata, Hive and Oracle
Possess excellent Communication, Interpersonal & Analytical skills. Abilities in working in strict deadlines and diverse conditions.

TECHNICAL SKILLS

Databases: Oracle 10g,TeraData, Hive

ETL: Data Ware Housing Concepts, Informatica Power Center, Informatica Developer (BDE), IBM DataStage

Tools: Autosys, PVCS, Dollar Universe, Kintana, TES, Artifactory

Scripting: Shell scripting

PROFESSIONAL EXPERIENCE

Confidential

Programmer Analyst

Responsibilities:

Work with the Product Owners, Business Analysts and client areas to prepare functional specification during the project requirements stage.
Design, development and unit testing of mappings using informatica Power Center and IDQ for the requirements.
Creation of stored procedures for complex design like handling temporal and bi temporal table in Teradata.
Design and develop integrated solutions for complex requirements like handling multiple source windows, member and group address from Facets.
Automation of PBM loads by designing adjustment process for the existing manual adjustment process and handling the file loads validation through automated audit.
Design and development of archive and purge mechanism for incremental data tables for easier trouble shooting with flexible retention period of data at each table level.
Performance tuning of long running queries through redesign.
Automation of DB objects deployment process using batch script.

Confidential

Tech Lead

Responsibilities:

Brainstorming for the new design and architecture to be used for the jobs.
Building mappings and workflows using the current logic in powercenter ETLs.
Proactively identify the limitations and build workarounds to overcome the limitations and mitigate the risks.

Confidential

Tech Lead

Responsibilities:

Redesigning of the architecture which had bugs and needed stabilization
Proactive identification of risks with architecture provided and fixing them
Mentoring onsite and offshore team and training them in Informatica tool and new architecture KT sessions to multiple teams
Meeting timelines inspite of tight timelines and redesign implementation within time which was not planned as part of project.

Confidential

Tech Lead

Responsibilities:

Developed mapping, workflows and logic building for metrics
Handled ADT and DLP end to end coordinating with business directly
Reduced load and development time for replic creation.

Confidential

Technology Analyst

Responsibilities:

Creation of mappings, workflows as per the requirement.
Analysis of legacy data sources and converting them to ETL structure.
Creation of PL/SQL objects and building reports.
Fixing issues in mapping and workflows.
Performance tuning of ETL.
Creation of Autosys jobs.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship