Programmer Analyst Resume Englewood, Colorado - Hire IT People

SUMMARY

10 years of experience in Analysis, Design, Development, and Unit Testing of Software applications using Teradata and ETL tool Informatica
Currently associated with Confidential Technologies as a Team lead.
Highly experienced in Informatica Powercenter v8.6 and 9.x
Worked on most of the Informatica transformations including transformation cache
Worked on performance tuning of Informatica mappings
Highly Experienced in Teradata Database v.13 and v.14
Practical knowledge of Teradata Parallel Architecture, Hashing concepts, Primary Indices, Secondary indices, Join Indices, Hash Indices, NoPI tables, Partitioning, Set/Multiset tables
Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load, TPT to export and load data to/from different source systems
Expertise in constructing complex SQL queries in Teradata, Netezza and Oracle
Knowledge of different Datawarehousing Schemas (Star and Snow Flake) and Database Normalization concepts
Worked on Unix shell scripts for file handling, Database handling and error handling
Worked on Hive SQL for few projects
Worked directly with the business users for Marketing and Operations Projects
Ability to work independently and as a team and able to effectively communicate with customers, peers and management at all levels in and outside the organization.

TECHNICAL SKILLS

ETL Tools: Informatica 8.x/9.x:

Databases: Teradata 13/14.x, Netezza, Oracle 9i/10g:

Database Utilities: Teradata BTEQ,Multiload,Fastload,FastExport,TPT Netezza - NZSQL,NzLoader Oracle - SQLplus, SQLLoader

Languages: SQL, Shell scripting:

Scheduling Tools: Autosys 4.5:

Operating Systems: Windows Server 2000/2008, Unix (Solaris, AIX, HP-UX):

Data Modelling Tools: ERWin, Microsoft Visio:

Reporting Tools: Hyperion IR, Business Objects XI:

PROFESSIONAL EXPERIENCE

Confidential, Englewood, Colorado

Programmer Analyst

Responsibilities:

Interact with Business users to understand the business rules
Coordinate with the Business Analysts and Data Analysts to prepare the mapping document
Actively involved in designing logical and physical models for EDW and Datamarts
Create high level and low level design document
Create informatica mappings/workflows to extract data from source systems into Datawarehouse
Develop complex queries to translate the business rules
Use teradata utilities like multiload, fastload, TPT, BTEQ to load data
Evaluate the explain plan and tune the teradata queries
Create shell scripts for file handling, logging and error handling
Prepare use cases and unit test cases
Create autosys scripts to schedule the nightly jobs
Provide production support during deployment
Peer review the development of the team members

Confidential

Senior Software Developer

Responsibilities:

Analysis of Business Requirements & preparation of high level and low level Design Document.
Role as an ETL developer includes developing simple and complex mappings. Implementing complex business logics by using various transformations at mapping level.
Understanding business process flow to achieve Application performance.
Documenting Test Cases, Review Logs during unit testing for the different types of issues.
Adhere to high Quality process pools during the Project life cycle like Quality Center & code versioning in Informatica.
Coordinating with the QA team for the MTQ (Move to Quality) environment & SIT
Coordinating with the users during the UAT.
Coordinating with Support team for the MTP (Move to Production) activities.