We provide IT Staff Augmentation Services!

Sr Etl Developer/lead Developer Resume

VA

Senior ETL Developer

  • About 12 years of experience in the field of information technology.
  • Experienced in Analysis, Design, Development and Implementation of large-scale Data Warehouse projects in Airline, Financial, and Healthcare, Shipping and Retail Industries using Data Warehousing ETL tools (Informatica, SSIS) and Business Intelligence tool (Actuate).
  • About 8 years Development and Administration experience in ETL tools Informatica Power Center and SQL Server SSIS.
  • About 5 years of experience in Actuate report s development, maintenance and administration.
  • Good experience in different phases of full Data Warehouse implementation projects, Performed all dimensions of development including Extraction, Transformation, Loading (ETL) data from various source into Data warehouse and Data Marts using Power Center (Repository Manager, Designer, Server Manager, Workflow Manger, Workflow Monitor).
  • Very Strong data analysis skills.
  • Analyzed existing transactional database schemas and designed Star/Snowflake Schema models to support the business reporting needs and requirements.
  • Experience in modeling logical and physical Data Models using ERWIN and Microsoft Visio.
  • Extensive use of Sybase T-SQL, Sybase Stored procedures, SQL Server T-SQL, DB2,Oracle SQL and PL/SQL for data retrieval.
  • Experience in Performance tuning Stored Procedures, bench marking the existing stored procedures, verifying
  • Query plan, statistics I/O and indexes which are been picked by optimizer.
  • Created ETL mappings using Informatica Power center to move Data from multiple sources like Flat files, XML, Web services, SAP and relational sources (Oracle, Sybase, DB2 and SQL Server) into a common target area such as Data Marts and Data Warehouse.
  • Extensively worked on various transformations such as Expression, Filter, Aggregator, Lookup, Router, Update Strategy, Union, Normalizer, Java, XML and Sequence Generator.
  • Experienced in migrating Informatica code across various environments.
  • Experienced in Informatica Power Center Installation , security, general administration & upgrades
  • Experience in migration of Informatica servers to new data center.
  • Experience in Informatica IDQ installation and setup, Informatica Web services configuration, Informatica-SAP integration setup using Power Exchange to read and write data in SAP systems.
  • Experience in IDQ developer and IDQ analyst tools.
  • Gained knowledge of Informatica MDM through online training .
  • Involved in code reviews to facilitate the right Informatica coding practices.
  • Experience in converting SSIS ETL packages to Informatica mappings.
  • Gained Knowledge of Business Objects and Micro Strategy reporting tools.
  • Excellent DOS and UNIX shell scripting skills for retrieving files from FTP server and doing file manipulation operations as per the requirements.
  • Experience of creating scheduling jobs using Informatica, AutoSys and Control-M.
  • Involved in conducting JAD sessions with Business Team and all stake holders of the project for requirement clarifications and creation of business signoff documents.
  • Experience in creating design/technical specification documents for the new enhancements or fixes.
  • Proficient in interacting with Business Users, Developers, QA and Senior Management.
  • Experience in creating deployment document and effectively communicate with change management team for

Code migration.

  • Experience training business users.
  • Experience working with offshore development and QA team.
  • Production support (24x7) experience.
  • Hardworking with excellent problem solving skills and motivation to explore new technologies.

Technical Skills:

Data Warehousing Tools

Informatica Power Center 9.x/8.x,SQL Server Integration Services 2000/2005

Reporting Tools

Business Objects ,Actuate ,Micro Strategy

Databases

SQL Server 2005/2008 ,Sybase 12.0, Oracle 8i/9i/10g/119, Microsoft Access 2.0/7.0/2000

Version Control

Microsoft Visual SourceSafe, Rational Clear Case, Sub Version

Data Modeler

Erwin Data Modeling Suite, Microsoft Visio

Programming Languages

C++, Java, V.B, H.T.M.L and Java Scripting technologies

Job Scheduling tools

Autosys , Control-M ,SQL Agent, Windows, Unix

Confidential, VA

SR ETL Developer/Lead Developer

Confidential is the parent company for 11 brands that provide services to the travel industry, including catering, hospitality, provisioning and logistics. GGRIDW is the EDW built for the enterprise with various data marts for each subject area. The project business requirements need is to load Volaris, Delta, United and Air Canada Airlines Sales and Invoicing data into DW. BI team built an automated Gate Gourmet Retail Intelligence (GGRI) solution to integrate airlines data into GGRIDW data model.

Roles and Responsibilities:

  • Involved in end to end SDLC process of analysis, design, development, testing and implementation of new/enhancements of various data marts projects using different Project Methodologies (Water Fall, Agile...).
  • Conducted meetings with Business Users and all the stakeholders of the project for finalizing the ETL requirements.
  • Involved in Data Model design or enhancements of Data Marts based on the ETL project requirements.
  • Created ETL design and process flow documents from Business requirements Specifications.
  • Coordinated with source system users and monitored existing production ETL processes on a daily basis.
  • Created simple/complex ETL mappings in Informatica using various transformations like Expression, Source Qualifier, Filter, Joiner, Aggregator, Connected/Unconnected Lookup, Router, XML, Java and Update Strategy.
  • Mapplets and Reusable Transformations were created to prevent redundancy of transformation usage and maintainability.
  • Developed mappings to load Slowly Changing Dimensions Type-1 and Type-2, Fact tables.
  • To help Business objects Dashboard reports performance designed and loaded multiple aggregate tables from transaction detail table using Informatica.
  • Created Automated ETL feed workflow jobs incorporating all the event waits, command, session, decision tasks and making sure all the dependencies defined in the ETL process flow document are covered.
  • Created multiple SQL Server and PL/SQL stored procedures to implement the complex business logic requirements in data warehouse loads.
  • Performance tuned ETL jobs as well as database SQL/Stored procedures by creating/altering indexes and creating db table partitions.
  • Extracted data from heterogeneous sources like Flat Files, Oracle, SQL Server, SAP-BW, Web services and XML files.
  • Created DOS batch scripts for retrieving files from ftp server, to list them in indirect file list and perform pre validations on file based on requirements.
  • Created Error handling mechanism/process to load bad data to error tables as per business requirements.
  • Created database reconciliation process between Source and EDW tables.
  • Performed Informatica Admin tasks like code migration, repository creation and backups, security role or user creation, Workflow job scheduling etc.
  • Migrated Informatica servers to new data center by making the necessary configuration changes in server side.
  • Installed and setup Informatica Power center and Informatica IDQ.
  • Trained Business Users on IDQ developer and Analyst tool for data profiling, rules and score card creation.
  • Created Informatica-SAP connectivity setup using power exchange for Informatica-SAP integration projects.
  • Analyze and fix production data load errors on timely basis.
  • Followed Informatica Best Practices and Naming Conventions while developing the mappings, sessions and workflows.
  • Actively participated in the code review process and provided inputs to the team members.
  • Unit tested the code and closely worked with QA and UAT team members in resolving the defects.
  • Created Business Objects adhoc reports for data validations.
  • Worked with Micro strategy and installed Micro strategy reporting software on BI demo environment to facilitate POC demo by Micro strategy sales team.
  • Provide production support and troubleshooting of ETL feeds and Daily Scheduled reports.

Environment: Informatica 9.1, Oracle 11g, SQL Server 2005, SAP, Sub Version, Business Objects XI, Micro strategy, Windows.

Confidential

Senior ETL and Reports Developer

Confidential is a diversified financial services organization headquartered in the Philadelphia region. Confidential has been serving the financial needs of customers since 1905. Lincoln Financial companies offer a variety of financial products including annuities, life and employer markets. My primary roles involved in creating numerous Informatica ETL objects, Actuate reports, DB stored procedures, supporting existing SSIS packages, Informatica objects, and Actuate reports in production.

Roles and Responsibilities:

  • Involved in user requirements gathering, analysis, design, development, and maintenance of Informatica, SSIS and Actuate reporting objects.
  • Developed high level design documents and participated in the requirement analysis, evaluating the complex requirements to formulate the software development processes for Informatica ,SSIS and Actuate reporting objects
  • Utilized VISIO to document and present complicated data diagrams, and Flow charts.
  • Extracted and transformed data using Power Center from Flat Files and loaded into SQL Server DB.
  • Through knowledge of the Data Mart Development Life Cycle, Performed all dimensions of development including Extraction, Transformation, Loading (ETL) data from various source into Data warehouse and Data Marts using Power Center
  • Used transformations like Normalizer, Lookup, Aggregator, Expression, Sequence Generator, Router, Filter, Joiner and Union Transformations.
  • Created and used parameter files to provide values to the variable used across sessions and workflows of Informatica to reuse with multiple criteria to decrease maintenance.
  • Created data checks and implemented error strategies using the Database Logging.
  • Implemented data masking on SSN related fields.
  • Scheduled Power Center jobs using Autosys GUI and JIL scripts.
  • Created UNIX Shell Scripts for retrieving files from FTP server, achieving the source files, Concatenating files and finally to deliver them to remote shared drive.
  • Involved in the testing efforts of Informatica upgrade from 8.6 to 9.0.
  • Involved in testing of ETL/Report objects for SQL Server 2008 upgrade.
  • Modified and maintained existing SSIS ETL packages.
  • Configured Connection Manager Files and CMD files for SSIS packages to dynamic execution in different environments.
  • Scheduled SSIS packages using SQL Agent
  • Converted existing SSIS ETL packages to Informatica.
  • Involve in design, development, and maintenance of Actuate reports.
  • Developed custom component libraries for reusability.
  • Made extensive use of Actuate Foundation Classes (AFC).
  • Overridden various Methods like Fetch, Compare, OnRow, OnRead, BindToRow, Finish, used Single Input Filter and Memory Data Sorter.
  • Deploy and schedule the reports on the Actuate eReport Server for various users.
  • Trained User's on Creating Actuate Query Objects.
  • Created and maintained complex reporting stored procedures.
  • Performance tuned various stored procedures.
  • Involved in creating turnover and signoff Documents.
  • Responsible for supporting the business analyst in data analysis, adhoc reporting and query optimization tasks.
  • Used HP Quality Center to track the defects.
  • Provide production support and troubleshooting of ETL feeds and Daily Scheduled reports.

Environment: Informatica 8.x/9.x,SSIS 2005/2008, Actuate 8.x/9.x, SQL Server 2005/2008, DB2 9.x, Oracle 10g, Sales Force, UNIX

Confidential , NJ

Senior ETL/BI Developer

As a Data warehousing ETL/Reports developer for Confidential (Nippon Yusen Kaisha)/NYK logistics I was involved in creating solutions for the Shipping and Logistics world. ETL/Reporting solutions were created to enable the users to verify their cargo, booking or shipments, bl or documentation, account receivable, account payable and their statuses for each module. The company gets data from different Applications. The primary aim of this project is to integrate the data sources from existing system and to provide analysis to make business related decisions.

My primary role involved in creating numerous Informatica ETL objects, Actuate reports, Sybase stored procedures. The databases being used are Sybase, Sql Server and Oracle SQL, PL/SQL.

Roles and Responsibilities:

  • Designed and developed various ETL process to load the data from sources and load it into DWH tables
  • Used Informatica Power Center 8.5 for extraction, transformation and loading (ETL) of data in the data warehouse.
  • Performed data manipulations using various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter and Sequence Generator etc.
  • Designed, developed and validated the process of converting existing database objects into Informatica mappings.
  • Used Debugger to validate the data flow in mappings.
  • Migrated Informatica code across various environments.
  • Worked Efficiently with Designer tools including Source Analyzer, Warehouse designer, Mapping and Maple Designer, Transformations.
  • Developed and debugged various complex Actuate reports for business users as per requirements for time critical
  • Developed custom component libraries for reusability
  • Worked on creating Actuate reports using sequential, parallel and conditional sections
  • Lead a team of developers in an Onsite – Offshore model
  • Coordinated with business unit team, developers, and QA analysts for carrying out JAD sessions; resolved issues and brought consensus on requirements
  • Documenting the Technical specs for the new enhancements or fixes.
  • Created UNIX shell scripts and CRON jobs to FTP actuate generated csv reports to different global ftp sites based on report name.
  • Clear Case is used for Version Control, MQC for defects and HP Service desk for new issues/high priority business issues.

Environment: Actuate 8.x, Informatica 8.x, Sybase, Oracle, SQL Server, Erwin, Windows XP, UNIX.

Confidetial, AR

Actuate Developer

Confidential is one of the world’s largest consumer products companies that manufactures and markets leading brands in home care, personal care and drugs. The project scope is to develop various reports to analyze the sales of company products in different dimensions.

Roles and Responsibilities:

  • Developed and debugged various complex Actuate reports for business users as per requirements for time critical deployments
  • Business Friendly reports are designed using Information Objects (Type of report in Actuate).
  • Some Ad-hoc reports outputs are presented in Excel using Actuate Excel API’s.
  • Excel/CSV Files generated by reports are uploaded to server via SOAP Call using Actuate API’s written in Java by the report itself.
  • Involved in upgrading reports from Actuate 6.0 to Actuate 8.0 SP1
  • Was actively involved in discussions and meetings to improve the performance of the reports
  • Worked closely with Business Managers to understand the business process and to gather requirements whereby understanding the potential use of the report
  • Provided Suggestions to business users on how to make use of Actuate Features like Scheduling, Success and Failure Notifications, restricting users from accessing unauthorized data and other features of Actuate.
  • Stored Procedures are written keeping in mind the amount data that is processed from the underlying tables.

Environment: Actuate eRDPro 6.x/8.x, Actuate iServer, SQL Server, Oracle, Windows NT, Java, JSP

Confidential

SQL Developer

Roles and Responsibilities:

  • Created new database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in SQL Server 2000.
  • Wrote Transact SQL utilities to generate table insert and update statements
  • Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data

Environment: SQL Server 2000, T-SQL, Visual Basic 6, ASP, Windows NT server

Hire Now