Sr. Etl Developer Resume
Burlington, MA
SUMMARY:
- 8+ plus years of experience in the IT industry with Domain knowledge on Insurance, Health Care, Retail and Telecom Projects.
- Demonstrated an analytical ability to understand the business requirements, convert the business specification to technical document, develop and integrate solutions to meet the requirement.
- Created Business Requirements Documents (BRD), Source - to-Target or Lineage document for data warehousing applications.
- Worked on projects using Informatica which are related to migration, development and Integration of various systems using various versions of Informatica (10x/9x/8x).
- Proficient in Informatica Designer components such as Source Analyzer, Mapping Designer, Mapplet Designer, Transformation Developer (Re-usable transformations), Workflow Manager, Workflow Monitor.
- Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading.
- Developed complex mappings in Informatica using different transformations such as Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier, Expression, Union and Stored Procedure etc.
- Hands on experience in using Business Intelligence tools such as Microstrategy and Cognos.
- Worked on various relational databases like Oracle, SQL Server, DB2 in creation of SQL Queries required by the project.
- Aware of concepts related to PL/SQL programming and some other scripting languages such as UNIX.
- Extracted data from various sources like Oracle, DB2, Flat files, MS SQL SERVER, XML files and other open source databases such as Cassandra.
- Worked closely with Data Modellers in coming up with scalable relational and dimensional data models. Good understanding of Star Schema, Snowflake Schema and 3NF data models.
- Proficiency in Data Warehousing techniques for Data Cleaning, Slowly Changing Dimension (SCD) phenomenon, Surrogate Key assignment and Change Data Capture (CDC).
- Worked extensively with Slowly Changing Dimensions Type1, Type2 and Type3.
- Understand the business rules completely based on High Level document specifications and implement the data transformation methodologies.
- Experience in Performance tuning of Informatica sources, mappings, targets and sessions and SQL queries. Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.
- Developed unit test cases for testing the ETL logic.
- Experience in setting up batch jobs using Autosys and Control-M job schedulers.
- Strong knowledge on Agile SCRUM methodology, Waterfall model and Test Driven Development.
- Hands on experience in Production Support and Maintenance.
TECHNICAL SKILLS:
ETL Tools: Informatica 10.1/9.6/9.5.1/9.1.0/8.6, ODI
Reporting Tools: Microstrategy, Tableau, Cognos, OBIEE
Databases: Oracle 8i/9i/10g/11g/12c, IBM DB2, SQL Server, Netezza, MS-Access.
Operating systems: Windows 95/2000/NT/XP/Vista, UNIX.
Data Modeling Tool: Erwin 8x
Utilities: Oracle SQL Developer, TOAD, SQL*LOADER, SQL Navigator
Job Scheduling Tools: Informatica Scheduler, Control- M, Autosys.
Production Support Tools: JIRA, Remedy, HP QualityCenter, Bugzilla
Office Application: MS Excel, MS Outlook, MS Word, MS Visio.
PROFESSIONAL EXPERIENCE:
Confidential, Burlington, MA
Sr. ETL Developer
Responsibilities:
- Worked with Business Analysts to understand the requirements and convert them to technical specfications.
- Created multiple mappings that involved implementation of Business Logic to load data into staging area.
- Extracted data from mainframe source systems and applied the business logic to load data into target systems.
- Implemented the ETL logic based on the mapping document to load the data from various source systems to target systems.
- Developed mapping parameters and variables to support SQL overrides and create global parameter files for loading various source and target tables.
- Used existing ETL standards to develop mappings.
- Extensively worked on Informatica Power Center tools- Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager and Informatica Power Exchange.
- Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregator, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
- Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
- Developed workflows with multiple sessions and instances for same subject area.
- Worked on Partitioning of the Sessions and Performance Tuning of Informatica.
- Implemented Indexing, Partitioning and Parallelismstrategies to facilitate huge volume data loads.
- Scheduled workflows using Autosys Scheduler and configured them with Email task, Control task, Event-Raise task, Event-Wait task, Timer task, Command task, Assignment task and decision tasks.
- Loaded data into fact and dimension tables in that handled slowly changing dimensions of Type II to populate current and historical data to Dimensions tables in the data warehouse
- For some strategies implemented the SCD TypeI.
- Removed bottlenecks at source level, transformation level and target level for the optimum usage of sources, transformations and target loads.
- Performed Unit testing of Informatica ETL process to ensure ETL logic.
- Once successfully unit tested ETL mappings, workflows and worklets were successfully moved to QA environment.
- After thorough User Acceptance Testing code was migrated to production and I provided 24x7 production support.
- Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.
- Participated in test results document preparation for the project.
Environment: Informatica Power Center 9.6(Power Center Designer, workflow manager, workflow monitor), Oracle Data Integrator, Business Objects XI 4.1, PowerExchange, UNIX, SQL Developer, Erwin, SQL, PL/SQL, MS-Visio, MS Office, DB2, SQL Server, Oracle 10g/11g, Agile.
Confidential, NY
Sr. ETL Developer
Responsibilities:
- Interacted with Business Analysts to understand and analyze the requirements.
- Translated requirements into business rules & made recommendations for innovative IT solution.
- Worked closely with user decision makers to develop the transformation logic to be used in Informatica Power Center.
- Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Store Procedure, Rank, Update Strategy, Router and Sequence generator.
- Used Workflow Manager for Workflow and Session Management, database connection management and Scheduling of jobs to be run in the batch process.
- Developed number of complex Informatica Mappings, Mapplets and Reusable Transformations for different types of studies for Daily, Monthly and Yearly Loading of Data.
- Removed bottlenecks at source level, transformation level and target level for the optimum usage of sources, transformations and target loads.
- Captured data error records corrected and loaded into target system.
- Tuned Source System and Target System based on performance details, when source and target were optimized, sessions were run again to determine the impact of changes.
- Experienced in troubleshooting and fix the different Development/Production environment issues.
- Responsible for regression testing ETL jobs before test to production migration.
- Performed Database/ETL migrations from Dev. environment to Test/Training/UAT/Staging and PROD environments.
- Worked on Business Objects functionalities like Queries, Slice and Dice, Drill Down, Custom sorts, Cross Tab, Master Detail and Formulae.
- Experienced in deploying the code into releasing folder and placing it into Build and troubleshooting the build issues.
- Providing 24x7 production support.
- Worked on daily production incidents and triaging the defects.
Environment: Informatica Power Center 9.5.1(Power Center Designer, workflow manager, workflow monitor), Business Objects XI 3.3, WinSQL, UNIX, SQL Developer, Erwin, Putty, SQL, PL/SQL, MS-Visio, MS Office, DB2, SQL Server, Oracle 10g/11g,SAP Power Connect, VersionOne, Mingle, Sharepoint, Agile.
Confidential, Bentonville, AR
ETL Developer
Responsibilities:
- Analyzing the source data coming from different sources and working with business users and developers to develop the Data Model.
- Create functional specifications and work with application technical teams to create the high level and low level design documents.
- Working closely with user decision makers to develop the transformation logic to be used in Informatica Power Center.
- Developing mappings, workflows as per the requirement.
- Created flat file targets and XML file targets extensively.
- Worked with UNIX environment for maintaining parameter files.
- Prepare the implementation plan to deploy ETL jobs and batches in Dev, Test and Production environments.
- Provided Knowledge Transfer to the end users and created extensive documentation on the design and development changes.
- Resolving tickets opened by users for BO Production issues as well as access related issues.
- Performance tuning using round robin, hash auto key, Key range partitioning.
- Implemented efficient and effective performance tuning procedures.
- Handling High priority and criticality incidents.
- Handling work requests and project requests.
- Provided backup liaison with business and IT.
- Understanding the functionality of the application from the business prospective.
- Monitoring and maintaining the scheduled jobs.
- Providing 24x7 production support.
- Responsible for maintaining the Quality standards in all the phases.
Environment: Informatica Power Center 9.6.1/9.1(Power Center Designer, workflow manager, workflow monitor), WinSQL, UNIX, Business Objects, Erwin, SQL, PL/SQL, MS-Visio, MS Office, DB2, SQL Server, Oracle 10g/11g,SAP Power Connect.
Confidential, Fremont, CA
ETL Developer
Responsibilities:
- Designed the ETL Mapping Documents for development team members for their implementations.
- Worked on Informatica Power Center components- Source Analyzer, Data warehousing designer, Mapping Designer and Transformations.
- Promoted Informatica mappings from development to test to production environment.
- Used Informatica to extract, transform and load data from different input sources like flat files and XML files into Oracle 10g database.
- Created Informatica Power Center Mappings, Mapplets and Transformations using the Designer and developed Informatica sessions as per the business requirement.
- Involved in Fine tuning SQL overrides in Source Qualifier and Look-up SQL overrides for performance Enhancements.
- Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
- Migration between Development, Test and Production Repositories.
- Supported the Quality Assurance team in testing and validating the Informatica workflows.
- Did unit testing and System testing at ETL level in my mappings.
- Configured workflows with Email task, Control task, Event-Raise task, Event-Wait task, Timer task, Command task, Assignment task and decision tasks.
- Developed robust and effective error free workflows so that only clean and good data is loaded into Oracle Database.
- Follow-up on tickets and fixing the issues.
Environment: Informatica 8.1.2, Oracle 10g, SQL, PLSQL, Microsoft Excel, MS-Word, COBOL.
Confidential, Deerfield, IL
ETL Developer
Responsibilities:
- Gathered the Project Requirement and Worked on System Requirement Design
- Worked on ETL Specification and Logical & Physical Design documents
- Understanding the existing DATA MODEL and gathered and analyzed the business requirements to develop a data warehouse model and evaluated for the ETL purpose
- Coordination with the ETL & Reporting Development team with Design/Development approach to create a DW and Data Marts.
- Improved the existing process towards more automated, reduce failure risks, improve data quality and increased resource utilization.
- Extensively used Informatica Power Center as an ETL tool to integrate various sources and loaded the data into Datawarehouse.
- Writing data extracts (equities, market data etc) to Excel files so that Business-users can analyze the data extracts in spreadsheets. These data extracts are also used for high-level Business users reporting purposes.
- Develop complex transformations like Lookup, Aggregator, Expression, Router, Filter, Update Strategy, XML transformations.
- Creating/ Building and Running / scheduling Batches and Sessions/workflow using the Server Manager/Workflow Manager and automation of ETL process using Autosys.
- Worked on daily loads that include delta and change data capture logic and also worked with global and local variables at the workflow and the mapping levels.
- Involved in creating the procedures and functions to support the ETL logic as required.
- Worked on Unix Platform with respect to Informatica file transfers, generating logs etc.
- Worked on UNIX shell scripts for scheduling sessions, pre and post session scripts for data transfer needs, GFT mechanism etc.
Environment: Informatica Power Center 8.6, Informatica PowerExchange, Oracle 10g,Siebel 8,TOAD, MS Visio, UNIX Scripting (Ksh)