Etl Lead/sr. Etl Developer Resume
Pa Swiftwater, PA
SUMMARY:
- Over 10 years of IT experience in designing and developing Business Intelligence solutions in Data Warehousing with Informatica Power Center
- Over 3 years of experience in leading multiple ETL projects with 3 - 7 team members
- Experienced in the design and development of data warehouses/data marts, multi dimensional analysis, OLAP reporting and strategies for ETL mechanism using Informatica Power center/Power mart.
- Experienced in Data modeling using Dimensional data modeling, Star/Snow Flake schema, FACT & Dimension tables. Designed the databases using Sybase Power Designer.
- Extensively worked on Repository Manager, Workflow Manager, Workflow Monitor and Designer to develop Ma ppings, Mapplets, Reusable Transformations, Tasks, Workflows, Worklets to extract, transform and load data.
- Extensively used Informatica to load data from Flat files, Relational databases, XML and .XLS
- Strong experience in writing PL/SQL Stored Procedures, Functions, Packages, Triggers and Performance Tuning.
- Worked in various Industry Sectors such as Investment and Pharma sectors.
- Created mappings using Lookup, Aggregator, Joiner, Expression, Filter, Update strategy, SQL and Normalizer Transformations. Developed reusable Transformation and Mapplets by using Mapplet designer..
- Extensively worked on Database utilities like SQL*Loader, SQL Navigator and Toad.
- Extensive knowledge of Folder creation, version migration from older version into latest version. Developed common logic using Reusable transformations and mapplets.
- Experienced in migrating applications from one Environment to another like Dev to QA to PROD .
- Experienced in writing design documents, validating requirement, perform code review, code tuning
- Involved in 24*7 production support for ETL job runs and reporting.
- Experience in writing Testing scripts & scenarios based on Functional & Business requirements and solution design.
- Familiar with usage of tools like QC and JIRA for defect tracking.
- Knowledge of Hadoop framework technologies like Pig, Hive
- Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
- Excellent Verbal and Written Communication Skills have proven to be highly effective in interfacing across business and technical groups.
TECHNICAL SKILLS:
Operating Systems: UNIX, Windows 2000/98/95/3.1, Windows NT
ETL: Informatica Power Center 9.1/8.6/8.6.1/8.1.1/7.1. X/6.X, Power Exchange for SAP
GUI: Visual Basic 5.0/6.0, Visual InterDev 6.0, MS Excel, Microsoft Visio, Share Point, SQL Navigator and TOAD
Database: SQL Server 6.5/7.0/2000, ORACLE 7.x/8i/9i/10g/12, DB2, Netezza, MS Access
Languages: COBOL, C, C++, Java, SQL, and PL/SQL
Scripting Languages: Unix Shell Scripting, Perl Scripting
Internet Skills: Java Script, HTML&DHTML
PROFESSIONAL EXPERIENCE:
Confidential, Swiftwater, PA
ETL Lead/Sr. ETL Developer
Responsibilities:
- Participated in weekly team and business meetings to gather and analyze the business requirements and provide various inputs and updates on the day to today running of the project life cycle
- Assisted the project manager with estimates and also prepared the level of effort estimates.
- Performed business analysis and developed data flow diagrams and mapping specifications.
- Involved in the data mart dimension and fact tables design using star schema, snow flake schema based on the business requirements.
- Performed data Modeling and Database Design using Sybase’s Power Designer
- Supported the project team throughout the design, development and testing process and managed the team with 4-5 members.
- Developed complex informatica processes that integrate data from multiple sources including SAP (CRM, ECC systems), Oracle, XML,Flat Files.
- Modifed existing/created new Informatica ETL programs to meet changing customer needs.
- Extensively worked with Slowly Changing Dimension (SCD) Type-I, Type-II and Type-III dimensions and data warehousing Change Data Capture (CDC)
- Created reusable components like mapplets and worklets.
- Unit test processes to ensure proper functioning and collaborate with other team members during system and integration testing phases to ensure proper functioning as part of the larger system
- Involved in code reviews as per ETL/Informatica best practices and standards.
- Experience in migrating Informatica objects (Export/Import method) from one environment to another
- Wrote UNIX Korn shell scripts for file transfers/archivals/Email notifications
- Experience in developing PL/SQL Packages and Procedures in accordance with Business Requirements for loading data into database tables
- Developed and maintained database views and procedures in Oracle database which are used for Microstrategy (Business Intelligence Tool)
- Create deployment plans and involved in migration of code from Dev to UAT and UAT to Production environments
- Worked on Autosys/Control-M scheduler application to design and schedule Informatica workflows and also work on the Informatica administration.
- Involved in migration of the scheduled batch jobs from Autosys to Control-M
- Involved in the production support activities and on call rotation schedule.
- Assisted Informatica and Microstrategy developers in debugging performance related challenges.
Environment:: Power Center 8.6.1/9.1, Oracle 10g, SAP Power Exchange, Power Designer, WINSCP, UNIX, MS Excel, MS Visio, Access Database, Unix shell Scripting, Share Point, VSS, Autosys Scheduler, Control-M.
Confidential, Philadelphia, PA
Sr. ETL Developer
Responsibilities:
- Worked with Architecture Team for the project from gathering data from various sources.
- Developed overall data transformation and extract design and strategy for various sources.
- Created the ETL design & standard specification documents.
- Extensively used ETL to load data from Oracle 10g and flat files to Oracle 10g.
- Created the mappings by using various transformations like lookup, filters, router, normalizer, and stored procedures.
- ETL design provided for exception handling by performing necessary validations.
- Executed the sessions workflow for informatica mappings using unix shell scripts.
- Used unix shell scripts for data acquisition from the remote servers.
- Used Visual Source Safe for maintaining the entire project related documentation.
- Worked closely with the offshore team as necessary.
Environment:: Power Center 8.1.1, Oracle 10g, IPM, Erwin, UNIX, MS Excel, Microsoft Visio, Share Point, Siperian, Trillium, Unix/Perl Shell Scripting, VSS.
Confidential, Wayne, PA
Sr. Informatica Developer
Responsibilities:
- Worked with Architecture Team for the project from gathering data from various source systems systems to creating a Data mart in Netezza.
- Requirement analysis in support of Data Warehousing efforts.
- Created the ETL design & standard documents.
- ETL design provided for error detection and handling by performing necessary validations.
- Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
- Designed and developed Informatica Mappings to load data from various Source systems like flat files, SAP R/3 into the Staging area, HUB and then to the Data Mart.
- Extracted SAP R/3 data by generating ABAP Programs.
- Created mappings using Unconnected Lookup, Sorter, Aggregator, and Router transformations for populating target table in efficient manner.
- Created mapplets to return the applicaiton's batch control Row ID (PK) for the current batch process and to set the values that are used to populate the standard audit columns to use in multiple mappings.
- Used Workflow Manager to create Sessions and manage the Workflows using various tasks like Command, Decision.
- Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
- Participated in unit and system test process.
- Created unit test plans, test cases assumptions & validations for testing the developed Informatica mappings.
- Done extensive testing and wrote queries to ensure loading of the data.
- Performing troubleshooting and providing resolutions to ETL issues.
- Created UNIX shell scripting to create the Parameter files and also for quality checks.
- Extensively used MS Visio for creating dependency diagrams used for UC4 scheduling.
- Involved in designing and creating batches using UC4 (scheduling tool), monitored the jobs and extensively involved in enhancements.
- Experience in generating the required reports as necessary for data validation purposes as part of system testing.
- Extensively used Share Point for maintaining the entire project related documentation.
Environment:: Power Center 8.6 & 8.6.1, Business Objects XI R3.1, SAP R/3, Power Exchange, Netezza, WINSQL, UC4 Scheduler 6.0, Erwin, LINUX, MS Excel, Microsoft Visio, Share Point, Unix/Perl Shell Scripting.
Confidential
- Requirement analysis in support of Data Warehousing efforts.
- Created new mappings, Modified existing mappings, mapplets, reusable transformations Created mapplets to lookup dimension keys from all the tables to use in multiple mappings.
- Used various transformations like Lookup, Filter, Joiner, Aggregator, Expression, Router and Update strategy, Sequence generator in the mappings.
- Created unit test plans, test cases and reports on various test cases for testing the developed Informatica mappings and also tuned them for better performance.
- Extensively used Share Point for maintaining the entire project related documentation.
- Extensively used MS Visio for creating dependency diagrams used for UC4 scheduling
- Involved in designing and creating batches using UC4 (scheduling tool), monitored the jobs and extensively involved in enhancements
Environment:: Power Center 8.6.1, Business Objects XI R3.1, Oracle 10g, Toad 8.6.1, JIRA, UC4 Scheduler 6.0, Erwin, LINUX, MS Excel, Microsoft Visio, Share Point, Unix/Perl Shell Scripting
Confidential , Omaha NE
Informatica Developer
Responsibilities:
- Analyzed business requirements and worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all applications and systems.
- Developed overall data transformation and extract design and strategy.
- Designed data loading sequence and populated data into Staging, ODS (Operational Data Store), Warehouse and Mart with business rules as per Data Warehousing Methodologies
- Created the mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookup, Router, Filter, and Update Strategy.
- Created Mapplets and used them in different Mappings for maintaining the standards.
- Designed and developed efficient Error Handling methods and implemented throughout the mappings
- Implemented informatica session partitioning like pass through, hash key and key range partitioning to reduce the load window.
- Created Sessions and managed the Workflows using various tasks like Command, Decision, Event wait, counter, Event raise, Email using Workflow Manager.
- Created unit test plans, test cases and reports on various test cases for testing the Informatica mappings
- Used Informatica Workflow Manager to create Workflows, Worklets and sessions to implement the logic embedded in the mappings.
- Involved in creating staging Tables, Indexes, Sequences, Views and performance tuning to load into tables, analysing tables, proper indexing and dropping.
- Created PL/SQL packages and procedures to build business rules to load data.
- Designed strategy and coded procedures to extract daily incremental data.
- Created UNIX shell scripting to run the sessions workflow for Informatics mappings.
- Developed materialized view for aggregate summary data.
- Involved in Performance Tuning of Informatics mappings, SQL Query, views etc.
- Provided production support on a daily basis for the load jobs.
- Involved in creating, scheduling, and running batches and sessions using Control-M (scheduling tool).
- Reviewed the business logic and documented the ETL development process.
- This project is Development including Production support. Analyze, design, build, test and implement change requests for certain areas in the production data warehouse.
- Provided assistance and support to MIS team in understanding of data and designing Business objects reports
Environment:: Informatica 6.2, XML, PL/SQL, Oracle 8i/9i, TOAD, Business Objects 6.1, Control-M and Windows 2000, Informatica Power Center 7.1.2, Windows 2003, XP