We provide IT Staff Augmentation Services!

Senior Developer Resume

3.00/5 (Submit Your Rating)

SUMMARY

  • Having 7+ years of experience in development, maintenance, support and enhancement in Informatica Powercenter.
  • Have a clear understanding of Data Warehousing concepts with emphasis on ETL and life cycle development.
  • Extensive experience in Extraction, Transformation and Loading of Data into Enterprise Data Warehouse using Informatica PowerCenter 9.x, 8.x,7.x versions.
  • Strong experience in Designing the Workflows, Mappings, creation of Sessions and scheduling them using Informatica PowerCenter 9.x, 8.x, 7.x versions.
  • Extracted the data from the SAP source systems SAP BW and SAP ECC and loaded the data into ODS tables.
  • Varied experience in Designing and developing the complex mappings from various Transformations like Source Qualifier, Joiner, Aggregator, Router, Filter, Expression, Lookup, Sequence Generator, Update Strategy, Normalizer and more.
  • Experience in Debugging sessions and mappings, Performance Tuning of the Sessions and mappings, implementing the complex business rules, optimizing the mappings.
  • Proficiency in data warehousing techniques for Data cleansing, Slowly Changing Dimension phenomenon, Surrogate key assignment.
  • Experience in Implementing the Informatica MDM (Master Data Management) process for Customer and Product Master Data Implementation.
  • Experience in extraction of data from various Heterogeneous sources (Relational database, Flat Files, SAP Source Systems, XML Files) to load into Data Warehouse/Datamart targets.
  • Proficient in understanding business processes/requirements and translating them into technical requirements.
  • Worked with DBMS like Oracle 9i/10g/11g, MS SQL Server.
  • Experience in Database development skills using Oracle PL/SQL to write stored procedures, functions, packages and triggers.
  • Extensive development, support and maintenance experience working in all phases of the Software Development Life Cycle (SDLC) especially in Data Warehousing and Business Intelligence.
  • Prepare/Maintain documentation on all aspects of ETL processes, definitions and mappings to support knowledge transfer to other team members.
  • Excellent interpersonal and communication skills, customer skills, documentation skills and desire to work in dynamic and challenging environments.
  • Work exceptionally well in a team or in an individual environment (self starter).
  • Ability to learn new technologies and tools quickly.

TECHNICAL SKILLS

ETLTools: InformaticaPower Center 9.X/8.X/7.X, Power Exchange, IDQ, Informatica MDM, Informatica DVO

Databases: Oracle 9i/10g/11g, DB2, SQL Server 2005/2008

Reporting Tools: Cognos, OBIEE

Data Access Tools: TOAD, SQL Navigator, Oracle SQL Developer

Programming Languages: COBOL, JCL, SQL, PL/SQL, Unix Shell scripting

Version Control Tools: Sub Version, SharePoint

Scheduling Tools: Autosys, Robot, Informatica Job Scheduler

Operating Systems: MS DOS, Win 98/2000/XP/7/8, UNIX, Linux

Other Tools: SAP BW 7.3, SAP ECC 6.0, Win SCP, Putty, JIRA, HP ALM, HP Quality Control, Assembla

PROFESSIONAL EXPERIENCE

Confidential

Senior Developer

Responsibilities:

  • Analyzed business requirements, performed Impact Analysis, created technical design specifications, developed code, performed Code Deployment and provided production support.
  • Developed various transformations like Source Qualifier, Update Strategy, Lookup & Expression transformation, Expressions and Sequence Generator for loading the data into target table.
  • Implemented the Change data capture(CDC) using the Informatica Power Exchange.
  • Extracted the data from SAP ECC and BW system’s and loaded the data into ODS tables.
  • Improved performance by using Explain Plan, Creating appropriate indexes, queries optimization, utilizing tablespaces and partitioning schemes.
  • Scheduled the Workflows using the Job Scheduler Skybot.
  • Responsible for identifying the missed records in different stages from source to target and resolving the issues.
  • Extensively worked in the performance tuning for mappings and ETL procedures both at mapping and session level.
  • Worked closely with database administrators and application development team(s) on the design and implementation of the database.
  • Created Landing tables, Staging tables, BO tables, Mappings, transformations for the MDM development.
  • Setting Trust configuration and Validation Rules, Created Match Rules and Merge Settings for MDM process.
  • Configured the data flow Land, Stage, Load, Tokenize, Match, Consolidate
  • Created Query and Packages in HUB for performing CRUD operation using SIF API
  • Created Informatica Data Director (IDD) UserExits to perform server side validations.
  • Deployed userexit using IDD configurations.

Environment: Informatica Power Center 9.1, Informatica Power Exchange, Oracle 11g, Informatica Data Quality(IDQ), SAP BW 7.3, SAP ECC 6.0, Toad, Skybot, PL/SQL (Stored Procedures, Triggers, Packages), Informatica MDM,HP ALMCompany: Thakral One Solutions Pvt Ltd

Confidential

Senior Developer

Responsibilities:

  • Created different transformations for loading the data into target database using e.g. Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, Sequence Generator.
  • Involved in Informatica administrative work such as creating Informatica folders, repositories and managing folder permissions.
  • Analyzed source data and gathered requirements from the business users.
  • Maintained warehouse metadata, naming standards and warehouse standards for future application development.
  • Coordinating with source system owners, day - to-day ETL progress monitoring, and maintenance.
  • Extensively used various tasks like Session task, Event Wait task, Decision task, Email task, Command task.
  • Migration, maintenance and support for Informatica interfaces/projects
  • Extensively involved in performance tuning for Informatica and Database side.
  • Involved in Optimizing the Performance by eliminating Target, Source, Mapping, and Session bottlenecks.
  • Created Reference Mappings by implementing SCD (Type1 and 2).
  • Extensively involved in writing SQL queries, creating PL/SQL functions, procedures and packages.
  • Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules.
  • Created mapping documentation for all the existing mappings and tuning of these mappings.
  • Used Mapping Parameters and Variables, Reusable Transformations.
  • Involved in creating Pre and Post Session SQL statements.
  • Scheduled the Workflows using the Job Scheduler Autosys.
  • Used Sub version tools to maintain the different version of the Informatica Code and documents.

Environment: Informatica PowerCenter 8.6, Power Exchange, Sub Version, Oracle 10g, SQL, HP Quality Control, Autosys, Unix Shell Scripting, Windows NT, Toad, Flat Files.

Confidential

Senior Developer

Responsibilities:

  • Involved in the design, development and implementations of the Enterprise Data Warehouse (EDW) process and Data mart
  • Worked on the analysis, design and development to ensure the successful implementation of the data loading processes.
  • Set up connection parameters for the source and target using Relational Connections and to hold the path for source and target.
  • Involved in analysis and performance of mappings/sessions. Increased performance by tuning the transformations and discussing database issues with the DBA.
  • Worked with Data Extraction from Relational DBMS and Flat Files.
  • Developed Mappings using Active Transformations such as Aggregator, Filter, Joiner, Router, Sorter, and Union Transformations.
  • Also used Passive Transformations such as Expression, Lookup, and Sequence Generator in various mappings.
  • Created and used reusable Transformations for easier maintenance of the data.
  • Integrated data cleansing processes within the Mappings. Performed debugging of Mappings using the Debugger for failed Mappings.
  • Created Workflows and Sessions to carry out loading process into the target.
  • Created and used Workflows using different Tasks like Session, Command and Timer.
  • Worked with Workflow and Session Log files to troubleshoot the encountered errors.

Environment: Informatica Power Center 8.1, Oracle 10g, TOAD, Unix shell scripting.

Confidential

Informatica Developer

Responsibilities:

  • Analyzed the sources, Targets, Transformed the data and Mapped the data and loading the data into Targets using Informatica.
  • Developed the Mappings using the Transformations required in Informatica Tool according to technical specifications.
  • Testing and maintaining of Informatica Mappings.
  • Involved in Integration test cycles.
  • Created tables, views, synonyms and sequences. Used SQL Loader for data loading.
  • Optimized queries using rule based & cost based approach.

Environment: Informatica Power Center 7.2, Oracle 9i/10g, SQL/PLSQL, TOAD and UNIX.

We'd love your feedback!