We provide IT Staff Augmentation Services!

Developer Resume

New, JerseY

PROFESSIONAL SUMMARY:

  • Over 5 years of IT experience in all phases of Software Development Life Cycle (SDLC) which includes User Interaction, Business Analysis/Modeling, Design, Development, Integration, Planning and testing and documentation in data warehouse applications, ETL processing and distributed applications
  • Strong expertise in using ETL Tools Informatica Power Center 9.6 (Repository Manager,Designer,Workflow Manager, Workflow Monitor), IDQ, PowerExchange and ETL concepts .
  • Experienced in writing SQL, PL/SQL programming, Stored Procedures, Functions, Cursors,Triggers, Views, Materialized Views, indexes, partitions, table partitions and query performance tuning.
  • Worked with various transformations like Normalizer, expression, rank, filter, group, aggregator, lookup, joiner, sequence generator, sorter, SQL, stored procedure, Update strategy, Source Qualifier.
  • Data Modeling: Data modeling knowledge in Dimensional Data modeling, Star Schema, Snow - Flake Schema, FACT and Dimensions tables.
  • Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
  • Extensive experience with Data Extraction, Transformation, and Loading (ETL) from disparate data sources like Multiple Relational Databases (Teradata, Oracle, SQL SERVER, DB2), VSAM, XML,Webservices and Flat Files.
  • Experience in working with POWER EXCHANGE to process the MainFrame files (IMS).
  • Experience in working with POWER EXCHANGE in implementing Change Data Capture CDC.
  • Designing and developing Informatica mappings including Type-I, Type-II, Type-III slowly changing dimensions (SCD).
  • Coordinating with Business Users, BI teams, functional Design team and testing team during the different phases of project development and resolving the issues.
  • Experienced in Teradata SQL Programming and Worked with Teradata utilities like Fast Load and Multi Load and Tpump and Teradata Parallel transporter.
  • Experienced in using advanced concepts of Informatica like PUSH DOWN OPTIMIZATION (PDO), PIPELINE PARTITIONING.
  • Good hands on experience in writing UNIX shell scripts to process Data Warehouse jobs.
  • Good skills in defining standards, methodologies and performing technical design reviews.
  • Executed software projects for Banking and financial services.
  • Good communication skills, interpersonal skills, self-motivated, quick learner, team player.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.6, Data Stage 8.7,InformaticaPowerExchange

Languages: SQL, TSQL,PLSQL,UNIX Shell Scripting

Methodology: Agile RUP, SCRUM, Waterfall

Databases: Teradata14/13/v2r12/v2r6/v2r5,Oracle11i/10g/9i,DB2,SQLSERVER2005/2008,Netezza

Operating Systems: Windows, UNIX, Linux

IDEs: TOAD, Teradata SQL Assistant, SQL * Loader.

Scheduling Tools: Control-m, Autosys, Tidal,Automic,Cron

Tracking Tool: Rally,SharePoint, JIRA, VersionOne

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

Developer

Environment: Informatica Power Center 9.6, Teradata.

Responsibilities:

  • Involved in preparing STTM Documents with BSA.
  • Preparation of Design documents, Understanding document and Technical Specifications.
  • Developed Several Mappings using transformations like Aggregator, Sorter, Expression, Router, Update strategy, Joiner and Look up transformations etc.to load the data from different Sources in to Relational tables.
  • Attending Client calls to update project status.
  • Responsible in supporting the SIT & UAT runs and supporting them for business clarifications.
  • Improving performance of Informatica mappings which requires additional tuning created by fellow team members.

Confidential, Denver

Developer

Environment: Informatica Power Center 9.6, Oracle 10g, FACETS, ESP Scheduler.

Responsibilities:

  • Liaising with user in business requirements gathering.
  • Preparation of BRD.
  • Preparation of Design documents, Understanding document and Technical Specifications.
  • Implementation of change requests.
  • Developed Several Mappings using transformations like Aggregator, Sorter, Expression, Router, Update strategy, Joiner and Look up transformations etc.to load the data from different Sources in to Relational tables.
  • Attending Client calls to update project status.
  • Coordinate with team members to guide and review the work done by them.
  • Monitor Informatica and Facets batch jobs in ESP scheduler.
  • Improving performance of Informatica mappings which requires additional tuning created by fellow team members.

Confidential, Des Moines-IOWA

Developer

Environment: Informatica Power Center 9.6, Sybase, Teradata.

Responsibilities:

  • Responsible for gathering the requirements as per the design documents & mapping documents given.
  • Identifying the issues in the Detail Physical Document & Source to Target Document.
  • Verifying the table DDL’s as per the Source to Target Document given.
  • Implementing the Logic of Change Data Capture (CDC) and loading the Staging tables & the Atomic tables using the Teradata Parallel Transporter connection.
  • Responsible for preparing the KSH scripts for running the Informatica jobs.
  • Responsible for preparing the Configuration files that are required for KSH scripts.

Confidential, Louisville.

ETL Developer

Environment: Informatica Power Center 8.6, 9.0, Sql Server 2005, UNIX.

Responsibilities:

  • Requirement Gathering and analysis of the specifications provided by the Users.
  • Preparing Project Documentations.
  • Extracted, Transformed and Loaded (ETL) data from different sources (Sql Server, Mainframe, and Flat file) to Relational tables.
  • Unit testing the code.
  • Fixing the bugs raised by ETL Testing team.
  • Coordinating with ETL Testing and Production team for timely releases.

Hire Now