Programmer Analyst Resume

SUMMARY

Previously associated with Confidential . as a Programmer Analyst and worked as an ETL Developer.
More than 2 years of overall experience in Development and Enhancement of business applications
Strong technical skills in Unix Shell Scripting, Informatica PC, Greenplum and Oracle database
Experiences in workload automation tools like BMC Control - M 8.0 and Control-M enterprise Manager 6.4
Used Control M Scheduler in creating and scheduling the job’s run timings.
Responsible for on call Production Support and Issue Resolutions using Session Logs, and Workflow Logs.
Responsible for best practices like naming conventions, Performance tuning, and Error Handling.
Experience in handling team, taking up responsibilities, interacting with clients and higher management, mentoring new team members
Interact with business users as well as other members of IT outside of the team. Involved in preparation of specifications, development and testing of scripts.
Designed and developed Operational Data Store, Slowly Changing Dimension, Staging areas.
Designed and developed complex aggregate, join, lookup transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica Power Center 9.x tool.
Developed complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy Rank and Router transformations.
Proficient in using Informatica Workflow Manager, Workflow monitor to create, schedule and control Workflows, Tasks, and Sessions.
Extensively worked with SQL queries.
Interacted with Informatica admin, Data Architect, DBA in troubleshooting problems reported in huge volume testing (150-200 Million records Data) systems.
Having the ability to analyze and diagnose failures in jobs; to do impact analysis of a data issue and trace it back to source system and to resolve data quality issues< -- Deleted:s -->< -- Inserted: z -->< -- Inserted: the -->
Experienced in preparing outage plans to support production jobs during DB server upgrades, Outages and Informatica upgrade
Having experience in L2 and L3 24x7 production support environment and working on Remedy as ticketing tool

TECHNICAL SKILLS

Hardware / Platforms: Windows XP, Windows 7, Windows 8, Windows 10, Ubuntu

Database: Oracle, Greenplum, MySQL

Programming Languages: SQL, PL/SQL, Postgresql, UNIX Shell scripting

ETL Tools: Informatica Power Center 9.1.0, 9.5.0 & 9.6.0

Other Tools: SQL Developer 3.2.4, PG Admin, Putty, Control M

Other Platforms: Citrix Receiver and Citrix XenApp

PROFESSIONAL EXPERIENCE

Confidential

Programmer Analyst

Responsibilities:

Created and enhanced the Informatica mappings, sessions and workflows according to the requirement.
Testing of the new and changed system with proper documentation.
Handled source files - XML files, flat files, CSV< -- Deleted:csv -->< -- Inserted: CSV -->
Preparing migration document for moving the application to different environments.
Written SQL overrides in Source Qualifier according to business requirements.
Strong in SQL queries
Created Sessions and Workflow for designed mappings.
Used Workflow Manager for Creating, Validating, Testing and running the Sessions and scheduling them.
Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
Responsible for providing 24/7 production support for daily job and ETL loads.
Created an automated ETL summary report which consists of the summary information for all the loading activities done each day
Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions.
Creating UNIX scripts for file transfer and for automated reports.
Involved in preparing outage plans to support production jobs during DB server upgrades, Outages and Informatica upgrade

Confidential

Developer

Responsibilities:

Developed Informatica objects and Oracle tables
Involved in ETL designing process
Implemented ETL processes using Informatica to load data from Flat Files to target Oracle Data Warehouse database.
Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
Designed and developed Operational Data Store, Slowly Changing Dimension, Staging areas.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship