We provide IT Staff Augmentation Services!

Senior Dw/etl Developer & Etl Team Lead Resume

4.00/5 (Submit Your Rating)

New York, NY

SUMMARY

  • 9+ years of IT experience in various phases of IT projects such as system analysis, design, development and testing.
  • Extensive experience in the implementation of Database/Data warehouse/ODS/ Data Marts for Financial, Logistical and Health & Pharma - Clinical Trials. Working as ETL/DB lead for development & migration of projects.
  • Solid experience in Data warehousing, Data Architecture & Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center 6.x/7.x/8.x/9.x (Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation developer, Mapplets Designer, Mapping Designer, Repository manager and Informatica server).
  • Extensive exposure in Dimension Data Modeling, Star Schema Modeling and Snowflake modeling. Good understanding of Data Management, Data Convergence, Business Intelligence (BI), OLAP, OLTP and ERP concepts.
  • Extensive experience in developing stored procedures, functions, Views, Sequences and Triggers, Complex queries using PL/SQL & SQL in Oracle 9i/10g/11g, Sybase and MSSQL.
  • Expertise in scheduling jobs by Control M scheduling tool. Implementing convoluted scheduling jobs using Control M & UNIX Shell scripts.
  • Expertise in all the phases of System development life Cycle (SDLC) & Agile Methodologies and complete exposure to Project Process management skill sets from Initiation to Closing with leadership, motivation, conflict resolution, change and team building ability.
  • Experience in various ETL development projects in analyzing & translating business requirements to technical requirements, allocation of tasks to team, development, TEMPeffective code review, testing, implementation, post-implementation reviewand production support.
  • Expertise in implementing complex Business rules by creating robust Mappings, Mapplets, and reusable objects using Informatica Power Center.
  • Experience in reusable code design to leverage application architecture/framework capabilities and functionality.
  • In depth knowledge in Control M Enterprises Tool, which is used for schedule the Control M jobs to execute various commands in different UNIX servers.
  • Strong ability to quickly learn, comprehend business processes and problems in order to TEMPeffectively develop technical solutions to their requirements. Always ready to take the initiative and aggressive pursuer of project/task deadlines without compromising on the quality of the deliverables or process compliance.
  • Experience in debugging, troubleshooting, monitoring and performance tuning in Informatica and SQL queries. Extensive working experience in maintenance and Production support of different applications.
  • Worked closely with BI Data Architect, Business Analysts, Business users, Application Architects, Development team, Production DBA's & Networking team in handling Setup, maintaining and upgrades of distributed environment.
  • Provided training to various new employees and assist with expert knowledge on all production processes. Documented all production applications and resolved all application issues and answered all requests.
  • Assist the team technically in case of any technical challenges faced by the team. Ensure the deliverables are delivered as per schedule and the project plan. Responsible for offshore team deliverables. Tracking and Reporting the progress of different requirements in project on a daily/weekly/monthly basis using internal Project Management Tool.

TECHNICAL SKILLS

ETL: Informatica PowerCenter 6.x/7.x/8.x/9.x (Mapping Designer, Work Flow Manager, Work Flow Monitor, Mapplet & Transformations)

Databases: Oracle 9i/10g/11g, MS SQL Server, Sybase 12.x/11.x

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, FACT and Dimensions Tables

Environment: Windows 2008/2007/2005/ NT/XP/7, UNIX, MS-DOS

Tools: BMC Control M, SQL *PLUS, Rapid SQL, SQL Developer, Eclipse, Tortoise, putty, winscp, FileZilla, WSFTP, WinMerge, Visio, MS Office

Scripting/Programming languages: SQL, PL/SQL, UNIX Shell Scripting (KSH), Perl, C, Java

Web Technologies: HTML, Struts, Servlet, Portlet, JSP, XML, Java script

Professional Experience

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Senior DW/ETL Developer & ETL Team Lead

Responsibilities:

  • Gatheird requirements by conducting meetings and brainstorming sessions with end users (Funds Surveillance users) and documented them.
  • Worked directly with J.P. Morgan Worldwide Securities Services (WSS) to consume multimanager funds positions, transactions, currency forwards, collateral, derivatives underlying securities details & illiquid securities.
  • Interacted with common services team to in corporate ETF products transactions & positions in existing compliance applications without any impact.
  • Involved in breaking down entire project into sprints and provide assistance to the Project Manager on planning. As scrum master, assigned the work to all team members and coordinating with all teams working in various projects.
  • Responsible for the Data Modeling and populating the business rules using mappings into the Repository for Meta Data management.
  • Performed analysis, design, development and maintenance activities associated with the database and data in support of multiple applications.
  • Designed and created complex source to target mappings using various transformations inclusive of Aggregator, Look Up (Connected and Un-Connected), Joiner, Source Qualifier, Expression, Update Strategy, Sequence Generator, Union and Router transformations
  • Developed PL/SQL stored procedures and functions to handle various activities outside of Informatica ETL process.
  • Created mappings, mapplets, reusable transformations, workflows with Sequential session tasks and concurrent session tasks. Scheduled workflows and procedure by Control M scheduler.
  • Responsible for testing and validating Informatica mappings against the pre-defined ETL design standards and preparing and implementing the code to QA, UAT and production environments

Environment: Informatica Power Center 9.5, Flat files, UNIX, Oracle 10g/11g, Sybase, Control M scheduler, Ext JS, JAVA/J2EE

Confidential, New York, NY

Senior DW/ETL Developer & ETL Team Lead

Responsibilities:

  • Interacted with Compliance Users to know their Business views while gathering the product requirements and supported product owner to document product backlogs. Prioritized product backlogs and translated those requirements into sprints to assist the Project Manager on planning by agile methodology.
  • As scrum master, performed Sprint Planning Meetings, Daily Scrum Meetings, Sprint Review Meetings and Sprint Retrospective Meetings.
  • Distributed tasks across the team and responsible for offshore & onshore team deliverables. Assist team member in case of any roadblocks and reviewed the team deliverables.
  • Responsible for the complete design and development of ETL architecture for loads from source to stage to ODS to data mart.
  • Coordinated with source systems owners, day-to-day ETL progress monitoring, Data warehouse Target schema design (star schema) and maintenance.
  • Worked on Informatica PowerCenter - Source Analyzer, Target Designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations
  • Created standard and reusable Informatica mappings/mapplets using Lookup, Joiner, Rank, Source Qualifier, Sorter, Aggregator, Union and Router transformations to extract, transform and load data mart
  • Worked with staging area to perform data cleansing, data scrubbing, data filtering and data standardization process.
  • Created SQL, PL/SQL, stored procedures for implementing business rules and transformations.
  • Involved in the performance tuning of Informatica code, SQL, PL/SQL scripts, Database using standard performance tunings steps for better performance and theirby improving the load time.
  • Created Control M jobs and scheduled the tasks using Control M scheduler.
  • Created and executed test cases/scripts and completed unit integration and system tests successfully. Responsible for all activities in UAT to get sign off from users.
  • Deployment of Informatica Objects from Dev to QA, UAT, and Production environments. Provided warranty support for productions jobs.

Environment: Informatica Power Center 8.6.0, UNIX, Flat files, Oracle 10g/11g, Sybase, Control M, EXT JS, JAVA/J2EE

Confidential, Jersey City, NJ

Senior DW/ETL Developer & ETL Team Lead

Responsibilities:

  • Responsible to meet with business stakeholders and other technical team members to gather and analyze application requirements.
  • Prepared the Asset Segregation rules and reviewed with funds surveillance users. Prepared the technical functional specification document and solid database design.
  • Applied slowly changing dimensions like Type1 and 2 TEMPeffectively to handle the delta loads.
  • Distributed task across the complete team and closely monitored the progress to make sure all takes will be delivered on time.
  • Created ETL mappings using Informatica Power center to extract the data from multiple sources like Oracle, Sybase, csv, Delimited files transformed based on business requirements and loaded to Data Warehouse.
  • Developed several complex mappings in Informatica by variety of Power Center transformations and Mapping Parameters. Created mappings using transformations like Lookup, Aggregator, Expression, Router, Filter, Update Strategy, Stored procedure and Sequence Generator.
  • Created and configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager.
  • Designed and developed Oracle PL/SQL scripts for Data Import/Export, Data Conversions and Data Cleansing. Designed and developed Oracle PL/SQL Procedures to implement complex rules.
  • Developed the test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge
  • Created UNIX scripts to automate the activities like ftp & sftp. Scheduled these UNIX scripts, procedures execution and run informatica workflows by using Control M schduler.
  • Reviewed the offshore deliveries to make sure the quality of code and helped them on critical issues.
  • Created deployment objects to deploy Informatica power center objects & Database scripts to QA,UAT and PROD
  • Experienced in Shell and PL/SQL scripting for regular Maintenance and Production Support to load the warehouse in regular intervals. Supported daily nightly productions jobs on rotation basis

Environment: Informatica Power Center 8.6.0, UNIX, Flat files, Oracle 10g/11g, Sybase, Control M, EXT JS, JAVA/J2EE

Confidential

Senior DW/ETL Developer

Responsibilities:

  • Gatheird the ad-hoc requests on existing reports enhancements and performed detailed impact analysis to come up with better solution for the given requirement.
  • Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users dat provided appropriate scope of work for technical team to develop prototype and overall system.
  • Responsible for offshore deliverables. Dedicated the work to all team members, coordinated the team members and helped them in case of issues.
  • Replaced all JAMS scheduler jobs by Control M. As part of migration, replaced all BCP IN/OUT scripts with Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, and Connected and Unconnected lookups, Filters, Sequence, Union, Router and Update Strategy
  • Extensively worked with Informatica to load data from flat files, Oracle, MS SQL server to target database for LVTS, Security Capital, Rochester, International and CDS transactions feed.
  • Created SQL, PL/SQL, stored procedures for implementing business rules and transformations. Involved in optimizing existing SQL, PL/SQL Stored Procedures to handle high volume of data.
  • Extensively worked on tuning (Both Database and Informatica side) and theirby improving the load time
  • Performed technical reviews of code and test plans created by team members. Deployment of Informatica, Java, Control M & DB Objects from Dev to QA,UAT, and Production environments
  • Responsible for all activities in UAT to get sign off from users. Supported daily nightly productions jobs on rotation basis

Environment: Informatica Power Center 8.6.0, UNIX, Flat files, Oracle 10g, Sybase, Control M, VAP 7.2 & JSR 168 Portlet

Confidential

DB & ETL Developer

Responsibilities:

  • Developed the change requirements with client team and provided technical support to the team. Also Prepared Functional Spec & Unit test plans
  • Generated Target Flat Files and loaded the data into database tables using the Informatica Mappings and used extensively all types of Transformations.
  • Generated database scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
  • Developed SQL queries to fetch complex data from different tables in remote databases using joins, database links and logs.
  • Performed integration testing for various mappings. Tested the data and data integrity among various sources and targets.
  • Responsible for all activities in UAT to get sign off from users. Involved for resolving the production issues & queries.

Environment: Informatica Power Center 7.1.1, UNIX, Flat files, Sybase, Oracle 9i, Java, J2EE, VAP 7.2 & JSR 168 Portlet

Confidential

DB & ETL Developer

Responsibilities:

  • Created mappings, sessions, workflows and mapplets for data migration.
  • Used various Transformations such as Aggregator, Update Strategy, Union, Router, Sorter, Source Qualifier, Filter, Expression, Connected/Unconnected Lookup, Sequence Generator, and Joiner.
  • Developed complex mappings, scripts and procedures.
  • Created the sessions to move the data at specific intervals to target tables and flat files using Informatica Server.
  • Using Workflow manager for Workflow and Session Management, database connection management and Scheduling of jobs to be run in the batch process.
  • Re-writing the existing Informatica mappings and workflows to ensure the proper data flow according to the updated design document and data mapping sheet
  • Responsible for development of forms and interfacing the data selection from the database.
  • Developed Unit tests and separate User Acceptance test cases (UAT) to validate data against test scenarios.

Environment: Informatica Power Center 6.2, UNIX, Flat files, MSSQL, Java, J2EE & Struts

Confidential

DB & ETL Developer

Responsibilities:

  • Normalization of database to remove data redundancy. The models were developed in accordance with the rules of referential integrity.
  • Development of database tables, relationships and PL/SQL procedures and Functions.
  • Created database objects like Tables, Indexes, Synonyms, and Sequences.
  • Analyzed requirements and created Database Triggers for validations written in PL/SQL.
  • Involved in interacting with the business community to understand their requirements.
  • Transferred data from flat files into oracle using Informatica.
  • Created the Staging mappings for delta detection using the different Transformations (Expression, Lookup, Joiner, Filter, Router, Stored Procedure etc.)
  • Created PL/SQL procedures to generate patient’s reports.
  • Prepared QA testing scripts and Test Case document.

Environment: Informatica Power Center 6.2, UNIX, Flat files, Oracle 9i, Java, J2EE & Struts

We'd love your feedback!