Sr. Etl/informatica Developer Resume
Milwaukee, WI
SUMMARY:
- 8+ years of IT experience in analyzing business needs of clients, developing effective and efficient solutions and ensuring client deliverable within committed deadlines.
- Having experience in interacting with the client in requirement gathering.
- Proficient in analysis of user requirements and functional specifications.
- Having sound knowledge on OLTP, ODS and EDW data modeling (logical and physical design, and schema generation) using Oracle and MS SQL Server models & repositories.
- Extensive experience in loading high volume data.
- Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation.
- Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0, UDB, MS Access and Teradata.
- Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse.
- Strong Data Warehousing ETL experience of using Informatica 9.6/9.5/8.6.1/8.1/7.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
- Worked on Informatica Cloud to create Source /Target sfdc connections, monitor, synchronize the data in sfdc.
- Worked on creation of ICS based data synchronization and data replication and mapping configuration tasks.
- Strong Emphasis in reviewing End-to-End test requirements, assigning appropriate resources, and initiate the End-to-End planning process.
- Good understanding of the Software Development Life Cycle (SDLC).
- Used complex transformations like Lookup, Update Strategy, Sequence Generator and Stored Procedure while Developing Mapplets and Mappings using Informatica Designer Tool.
- Involved in Performance Tuning at mapping level and session level.
- Worked on designing and coding the complete ETL process using Informatica for various transactions and loading data from different sources like Flat Files, Web Services and Relational Database.
- Followed the Informatica Best Practices and Standards while creating Informatica Mappings, Sessions and Workflows.
- Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
- Expertise in working with relational databases such as Oracle 11g/10g/9i/8x and MS SQL Server 2008/2005.
- Hands-on experience with SCRUM Agile model, XP Practices like Pair Programming and Test Driven Development (TDD) .
- Hands-on experience writing Stored Procedures, functions, triggers, DDL, DML SQL queries. Experience in writing SQL, PL/SQL programming and SQL Loader.
- Good Knowledge in Dimensional Data modeling, Star/Snowflake schema design, Fact and Dimensional tables, Physical and Logical data modeling.
- Excellent ability with a competitive spirit in finding various approaches for problem-solving and highly skillful, creative and innovative in developing efficient logic/code.
- Proficiency in prioritizing and multi-tasking to ensurethat tasks are completed on time.
- Good Communication and interpersonal skills.
TECHNICAL SKILLS:
Informatica Tools: Informatica Power Center 10.1,9.6.1,ICS
Databases: Oracle 12c,11g/10g, SQL Server 2012/2008, MySQl, TeraData 14
Data Modeling Tools: Erwin 7.0/4.0, MS Visio
Query Tools: SQL Developer, Toad, SQL*Plus, SQL*Loader, T-SQL.
OLAP/Reporting Tools: OBIEE 10.1.3, Tableau
Languages: Unix Shell Scripting, Perl, XML, JSON, WSDL
Operating systems: Linux, Unix, Widows 10,7, Windows 2003/2007, Windows XP
IDE/Development tools: Eclipse, Toad
Development Methodologies: Agile, Waterfall, Test Driven Development
PROFESSIONAL EXPERIENCE:
Confidential, Milwaukee, WI
Sr. ETL/Informatica Developer
Responsibilities:
- Created detailed Technical specifications for the ETL processes.
- Performed ILIT (Irrevocable Life Insurance Trust) implementation and replacement activities.
- Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.
- Used Informatica as ETL tool, and stored procedures to pull data from source systems/ files, cleanse, transform and load data into databases.
- Worked on Informatica- Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.
- Developed the Informatica mappings using various transformations, Sessions and Workflows. SQL Server was the target database, Source database is a combination of Flat files, Oracle tables, People Soft, Excel files, CSV files etc.
- Worked with different Caches such as Index cache, Data cache, Lookup cache (Static, Dynamic and Persistence) and Join cache while developing the Mappings.
- Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing.
- Involved with the DBA in performance tuning of the Informatica sessions and workflows. Created the reusable transformations for better performance.
- Optimizing the Mappings and implementing the complex business rules by creating re-usable transformations and mapplets.
- Involved with the DBA in performance tuning of the Informatica sessions and workflows. Created the reusable transformations for better performance
- Involved in writing UNIX shell scripts for Informatics ETL tool to run the Sessions.
- Fixing and tracking mapping defects and implementing with enhancements.
- Managing post production issues and delivering task/projects within specific timeline.
- Involved in the mirroring of the staging environment to production.
- Worked on Modification of Actuate report to upload and run reports on servers.
- Worked on Autosys to schedule jobs, define dependencies etc.
- Collaborated with teams for migration and Production Deployment activities.
- Scheduling Informatica jobs and implementing dependencies if necessary, using Tidal Scheduler.
- Responsible for performing SQL query optimization using Hints, Indexes and Explain plan.
- Played a Vital role in requirement gathering, preparation of engineering gathering requirement specification.
- Using Perforce as a versioning tool for maintaining revision history for code.
- Managed production issues and delivered all assignments/projects within specified time lines.
- Worked on all phases of multiple projects from initial concept through research and development, implementation, QA, to live production, by strict adherence to project timelines.
Environment: Informatica Power Center 8.1 IBM UDB DB2, SQL server 2008, SSIS, doc Loader, Embarcadero Rapid SQL 7.7.1, Autosys, Text Exceed 14, UNIX.
Confidential, Miami, FL
Sr. ETL Developer
Responsibilities:
- Used Informatica Power Center 10.1 and its all features extensively to transform and load to Oracle 11g.
- Gathered requirements for the scope of loading data from various sources to database.
- Built Integration between various Sources.
- Extract Data from various sources, flat files to Transform and load into Staging.
- Designed and developed ETL Mappings using Informatica to extract data from flat files and XML, and to load the data into the target database.
- Creating ICS jobs to integrate on-premise systems like SQL Server and Teradata for enterprise finance reporting solutions.
- Creating ICS for Smartsheet systems for file attachment uploads.
- ETL experience of using Informatica 10.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools . Informatica Server, Repository Server manager.
- Implemented various ETL solutions as per the business requirement using Informatica 10.1.
- Worked with Informatica Cloud to create Source /Target connections, monitor, synchronize the data in sfdc.
- Worked with Informatica cloud for creating source and target objects, developed source to target mappings.
- Experience in integration of heterogeneous data sources like Oracle, DB2, SQL Server and Flat Files (Fixed & delimited) into Staging Area.
- Extensive experience in creating Transformations and Mappings using Informatica Designer to implement business rules and processing tasks using Workflow Manager to move data from Multiple Sources into Targets.
- Expertise in working with various transformations using Aggregator, Look Up, Update Strategy, Joiner, Filter, Sequence Generator, Normalizer, Sorter, Router, Java transformations in Informatica Power Center Designer.
- Worked with Variables and Parameters in the mappings. Experience working in Waterfall and Agile methodology implementations.
- Excellent Oral/Written/Interpersonal communication skills, quick learner, willing to adapt to the team and organizational environment.
- Used various Transformations like Router, Filter, Joiner, Update Strategy and connected and unconnected lookups for better data messaging and to migrate clean and consistent data using the Informatica Power Center Designer.
- Involved in the Development of Informatica mappings and Mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
- Worked on troubleshooting the Mappings to improving Performance by identifying bottlenecks.
- Performance tuning of the process at the mapping level, session level, source level, and the target level.
- Week on Week Status report to manager on the process and timelines.
- Worked on Informatica Cloud to create Source /Target sfdc connections, monitor, synchronize the data in sfdc.
- Worked with Informatica power exchange and Informatica cloud to integrate Salesforce and load the data from Salesforce to Oracle db.
- Used Informatica Scheduler and Autosys to schedule Informatica mappings.
Environment: Informatica Power Center 10.1, ICS, Teradata 16.10, Service Now, Oracle 10i/11g, Toad 7.5,XML, Erwin, SQL, PL/SQL, SQL plus, UNIX.
Confidential, Horsham, PA
Sr. Informatica Developer
Responsibilities:
- Worked as an ETL module developer.
- Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to various target systems(Sql server, Flat files) using Power Center of Informatica.
- Informatica Data Quality IDQ was used to identify Data Duplication and understand the quality of data. Used Informatica Data Explorer IDE tool for profiling the data prior to migration.
- Responsible for ETL solutions in ICS as Informatica Cloud Consultant.
- Develops XML files for downstream systems sourced from SFDC system using ICS.
- Loading the data from source data files to SFDC CRM product using ICS mappings.
- Analyzing the source data coming from Oracle, DB2, SQLSERVER AND FLAT FILES and working with business users and developers to develop the Model.
- Performed performance tuning of Informatica maps for more efficient loads.
- Did the development of Informatica Mappings and DAC Execution plans.
- Performing requirement gathering, analysis, design, development, testing, implementation, support and maintenance phases of both MDM and Data Integration Projects.
- Parsed high-level design spec to simple ETL coding and mapping standards, tested the data by running queries on the database for validation and accuracy.
- System Documentation of Dataflow and methodology.
- Assisted in designing Logical/Physical Data Models, forward/reverse engineering using Erwin 4.0.
- Developed mappings to extract data from Oracle, Flat files and load using the Power Center.
- Made use of mapping variable & mapping parameters and developed common routine mappings.
- Developed Slowly Changing Dimension for type 1and type II (flag, date).
- Made use of mapplets in order to save design time and effort.
- Executed, scheduled workflows using Informatica Cloud tool to load data from Source to Target.
- Master Data Management MDM Data Integration concepts in large scale implementation environments
- Involved in Informatica Admin work like installation, migrating workflows and mappings from Dev to staging and Production using Repository Manager and managing user and group privileges on Informatica Folders.
- Schedule the workflows by using DAC.
- Did the performance testing.
- Provide support and technical guidance to resolve support issues as needed.
Environment: Informatica Power Center 9.6.1, ICS, Oracle 10i/11g, Service Now, Toad 7.5,XML, Erwin, SQL, PL/SQL, SQL plus, MS SQL Server 2005, UNIX.
Confidential, Irving, TX
ETL/ Informatica Developer
Responsibilities:
- Identified data source systems integration issues and proposing feasible integration solutions.
- Partnered with Business Users and DW Designers to understand the processes of Development Methodology, and then implement the ideas in Development accordingly.
- Worked with Data modeler in developing STAR Schemas and Snowflake schemas.
- Created Oracle PL/SQL queries and Stored Procedures, Packages, Triggers, Cursors and backup-recovery for the various tables.
- Worked with Informatica Cloud to create Source /Target connections, monitor, synchronize the data in sfdc.
- Identifying and tracking the slowly changing dimensions (SCD).
- Create a logical model for Medical Benefit product MDM application Aka: PIM that will function as a master data for downstream applications claims, operations, regulatory, DW, BI, reporting system.
- Extracting data from Oracle and Flat file, Excel files sources and performed complex joiner, Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformations and Update strategy transformations to extract and load data into the target systems.
- Created reusable Mailing alerts, events, Tasks, Sessions, reusable worklets and workflows in Workflow manager.
- Scheduled the workflows at a specified frequency according to the business requirements and monitored the workflows using Workflow Monitor.
- Fixing invalid Mappings, Debugging the mappings in designer, Unit and Integration Testing of Informatica Sessions, Worklets and Workflows.
- Extensively used TOAD for source and target database activities.
- Involved in the development and testing of individual data marts, Informatica mappings
Environment: Informatica Power Center 8.6.1, Service Now, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange, SQL Assistant, SSIS, Windows NT, AutoSys, UNIX.
Confidential, Auburn hills, MI
ETL/ Informatica Developer
Responsibilities:
- Primary responsibility is to Load the data from legacy systems to Oracle 9i by using Informatica.
- Did the development of ORACLE Procedures, Informatica Mappings and Unix Shell Scripts.
- Creating the FDD, TDD and Master Build Documents.
- Worked with Informatica cloud for creating source and target objects, developed source to target mappings.
- Documented the Mapping and Transformation details, user requirements, implementation plan and schedule.
- Extensively used AutoSys for Scheduling and monitoring
- Designed and developed efficient Error Handling methods and implemented throughout the
- Mappings
- Schedule the workflows by using Redwood to perform an End to End Load for Batch runs.
- Responsible for Data quality analysis to determine cleansing requirements.
- Used Informatica PowerCenter 9.1 and its all features extensively to transform and load to Oracle 11g.
- Gathered requirements for the scope of loading data from various sources to database.
- Built Integration between various Sources.
- Extract Data from various sources, flat files to Transform and load into Staging.
- Designed and developed ETL Mappings using Informatica to extract data from flat files and XML, and to load the data into the target database.
- Worked with Variables and Parameters in the mappings.
- Used various Transformations like Router, Filter, Joiner, Update Strategy and connected and unconnected lookups for better data messaging and to migrate clean and consistent data using the Informatica PowerCenter Designer.
- Involved in the Development of Informatica mappings and Mapplets and tuned them for Optimum performance, Dependencies and Batch Design.
- Worked on troubleshooting the Mappings to improving Performance by identifying bottlenecks.
- Performance tuning of the process at the mapping level, session level, source level, and the target level.
- Week on Week Status report to manager on the process and Timelines
- Used Informatica Scheduler and Autosys to schedule Informatica mappings.
Environment: Informatica Power Center Designer 9.1, Informatica Repository Manager, shell scripting, SQL Assistant, Windows Vista, Erwin, AutoSys.
Confidential
ETL/ Informatica Developer
Responsibilities:
- Used Data vault model and maintained ETL (Data Extraction, Transformation and Loading) mappings accordingly as per the user requirements.
- Created mappings using Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router transformations, Union transformation, Stored procedure transformation.
- Used debugger to test the data flow and fixed the mappings.
- Implemented slowly changing Dimensions Type-1 and Type-2.
- Maintained version control to keep track of the changes in the Dev.
- Created Pre SQL scripts and Post SQL scripts in the workflow sessions when needed.
- Used Dynamic parameter files concept. Loaded parameters files using SQL Server 2008 database.
- Deployed Informatica objects from Dev to UAT and maintained versions at each deployment.
Environment: Informatica Power Center 8.6.1, Informatica Repository Manager, SQL Assistant, Business Objects, Shell Scripts, UNIX, Windows XP.
Confidential
Programmer Analyst
Responsibilities:
- Involved in the analysis of business requirements and keeping track of data available from various data sources, transform and load the data into Target Tables using Informatica Power Center.
- Involved in building and supporting the extraction flows.
- Identification and Documentation of various data sources including the detailed Table/File/Field level mappings between the source and target systems.
- Created Informatica Mappings to build business rules to load data using transformations like Source Qualifier, Aggregator, Expression, Joiner, Connected and Unconnected lookups, Filters and Sequence, External Procedure, Router and Update strategy.
- Tested mappings and sessions using various test cases in the test plans.
- Implemented SCD methodology including Type 1, Type 2 to keep track of historical data.
- Extensively worked on Mapping Variables, Mapping Parameters and Session Parameters.
- Created post-session and pre-session shell scripts and email-notifications.
Environment: Informatica Power Center 8.6.1, Business Objects, AutoSys, Ingres, Shell Scripts, HP UNIX, Windows XP, Erwin.