Senior Developer Resume
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.