We provide IT Staff Augmentation Services!

Lead Etl Datawarehouse Developer Resume

5.00/5 (Submit Your Rating)

Canton, MI

SUMMARY

  • Over 12 years of IT experience in Business/Application Software Development and support in Oracle Environment mainly in Client/Server - architecture under UNIX and Windows. Successful experience and strong skills in various aspects of software development life cycle (SDLC) in conversation wif SEI-CMM level 5 quality procedures.
  • Worked on various industry domains such as Life Science, Health care, Financial Projects, Commodities Exchange, Media & Entertainment. Possess good communication skills and TEMPhas dealt wif variety of global clients.
  • Experience in development and design of ETL (Extract, Transform and Loading data) methodology for supporting data transformations and processing, in a corporate wide ETL Solution. Experience in working wif DAC 11g/10g to define the Informatica workflow and sequence and schedule Informatica workflows.
  • Experience in mapping techniques for Type 1, Type 2 and Type 3 Slowly Changing Dimensions.
  • Experience in Informatica mapping specification documentation, tuning mappings to increase performance, proficient in creating and scheduling workflows and expertise in Automation of ETL processes wif scheduling tools such as Autosys and Tidal.
  • Experience in Performance Tuning at Mapping, Session and database level. Identifying and resolving performance bottlenecks at various levels in Business Intelligence applications. Applied the Mapping Tuning Techniques such as Pipeline Partitioning to speed up data processing. Conducted Session Thread Analysis to identify and fix Performance Bottlenecks.
  • Substantial experience in Code Design, Development, and debugging skills, offshore team management. Experience to lead projects and manage timelines for self and for the team.
  • Substantial experience of best PL/SQL programming techniques, performance tuning and database design.
  • Possess strong analytical abilities and ability to organize and manage time efficiently and to perform well under pressure. Exposure to Handle Project Management aspect of live projects including Project driving implementation scope finalization, Project planning, Process Implementation, Team management, Requirement’s analysis, Cost Estimation, risk management, projects plan & effort estimation, Project tracking, customer interaction, Release Management, Defect tracking tools and deliverables.
  • Worked wif business team to develop project schedules, provide status reports, identify risk and mitigation plan, and lead issue resolution till deployment and support process.
  • Good noledge of tools like Toad, Pl/SQL Developer, Informatica, DIH, Hadoop, HDFS, Hadoop Ecosystem, Hive. Experience in analysing data using Hive QL, importing and exporting data using Sqoop from Relational database systems to HDFS and vice versa.

TECHNICAL SKILLS

ETL Tools: Alteryx, Informatica Power Center 10.1,9.6, Power Exchange 9.5, 9.0.1, 8.x, 7.x (Designer, Workflow Manager, Workflow Monitor, Repository Manager, Repository Server, Administration Console) Metadata Manager, Data, IDQ.

Reporting Tools: Power Bi, SSRS, SSIS

Databases: RDBMS like Oracle 12c/Exadata/11g/10g, MS SQL Server 2008/2005/2000, MS Access, IBM, Netezza, Teradata

Data Modelling: Data Modelling, Dimensional Data Modelling, Star Schema Modelling, Snowflake Modelling, FACT and Dimensions Tables, Physical and Logical Data Modelling.

DB Tools: TOAD, SQL Developer, SQL Assistant, Visio, ERWIN

Operating System: UNIX, Linux, Windows XP/7

Languages: SQL, PL/SQL, XML

Scheduling Tools: Tivoli, Autosys, Control-M, Dollar Universe

PROFESSIONAL EXPERIENCE

Confidential, Canton, MI

Lead ETL Datawarehouse Developer

Responsibilities:

  • Gather business requirements from subject matter experts (functional experts) and translate them into specifications design. Design, develop, and maintain the dimensional model based on business needs requirements.
  • Data Extract and System Interface Development - Design data interfaces to support data warehouse processes. Design and implement queries to extract specific data from relational data sources into data warehouse. Establish controls to ensure the accuracy and consistency of data.
  • Provide ongoing support of the data warehouse, continued development and enhancement of the data warehouse, automation of daily data extracts and external system feeds, and development and enhancement of current reports.
  • Developed metadata tables, views, PL/SQLstored procedures. Develop, manage, and update data models, including physical and logical models of the data warehouse, and data mart.
  • Wrote scripts in Python and R for Extracting Data from JSON and XML files.
  • Involved in designing the Workflows in Alteryx to load xml data from external source to EDW and generate Power BI reports for the business for analysis.
  • Working on data migration project to move the data from oracle legacy system to AWS Redshift.

Environment: UNIX, Oracle, Alteryx, R, Toad, SQL Developer, Power BI

Confidential, Southfield, MI

Lead ETL Informatica Developer

Responsibilities:

  • Analysing the requirement for loading the data from EDW to internal database server.
  • Involved in designing the Workflows, Worklets, Mappings, Sessions and configuring the Informatica Server using Informatica Power Center.
  • Integrated the Informatica server wif DAC and customized the data warehouses in DAC.
  • Performance tuning of informatica mappings data warehouse loads, including informatica server manager and PL/SQL procedures. Done Unit testing at various level of ETL and wrote quires in SQL to ensure loading data in to target.
  • Developed metadata tables, views, PL/SQLstored procedures,for moving the data from staging area to DataMart. Created scripts to createnew tables, views, queriesfor new enhancement in the application using TOAD. Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
  • Worked on Informatica Power Center tools - Source Analyzer, Warehouse Designer, Mapping & Mapplet Designer, and Transformation Developer. Created mappings using transformations like Source Qualifier, Aggregator, Expression, lookup, Router, Filter, Update Strategy, Joiner, Normalizer, Union, Stored procedure, and XML transformations.
  • Converted existing PL/SQL Packages to ETL Mappings using Informatica Power Center.
  • Developed reports using SSRS dat could be used to send information to different Primary Vendors, Clients, and managers. Worked on formatting SSRS reports using the Global variables and expressions. Creating tables to provide infrastructure for data load and reporting
  • Creating the technical documents. Debugging code, testing and fixing of defects through ClearQuest.
  • Version control of documents using JIRA. Development in accordance wif Agile Methodology framework.

Environment: UNIX, Oracle, Shell Scripting, Informatica PWC, Toad, SQL Developer, SSRS, SSIS

Confidential, Louisville, KY

Lead ETL Developer, Onsite Team Lead

Responsibilities:

  • Analysing the requirement for creating reports for Claims and their Utilization pattern. Responsible for requirement gathering, assign responsibilities to offshore team
  • Backend development using in SQL and PL/SQL scripting. Creating Report code in SQL. Creating tables to provide infrastructure for reporting. Performance tuning of queries.
  • Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
  • PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE. Extensively involved in usinghints to direct the optimizerto choose an optimumquery execution plan. Involved in creation of dimensional schema design including dimension tables, fact tables. Good noledge on Query optimizer, Executions plans and Indexes.
  • Effectively made use of Table functions, Indexes, Table partitioning of fact tables, Analytical functions and views. Developed complex database objects like stored procedures, functions, Packages and Triggers using SQL and PL/SQL. Worked on database migration project from Oracle 12g to Exadata
  • Managed team for design, development, testing and implementation of jobs from dev to prod environment. Coordinated wif multiple teams for successful code deployment.
  • Created Informatica DIH workflows and mappings for data load.
  • Creating the technical documents. Testing, debugging and fixing of defects through Squids.
  • Version control of documents using TFS. Code deployment in accordance wif Agile Methodology framework.

Environment: UNIX, Oracle 12g, Exadata, PL/SQL scripting, Shell Scripting, Informatica DIH, DataStage, DB2, QlikView, Tortoise SVN, Dollar Universe.

Confidential, Louisville, KY

Sr Database Developer/Hadoop Developer, Offshore Team Lead.

Responsibilities:

  • Leading a module. Working wif clients to gather requirements. Analysing the requirement
  • Understanding the functional specifications document. Writing the technical design document. Unit and Integration Testing. Bug Fixing of the application in various areas
  • Backend development using in SQL and PL/SQL scripting. Creating Report code in SQL. Creating tables to provide infrastructure for reporting. Performance tuning of queries.
  • Experience in writingNZSQL,NZLOADandstored procedures. Experience inNetezza database designandworkload management
  • Improving the quality of application by using Performance Tuning concepts.
  • Worked wif semi structured and unstructured data. Worked on analysing Hadoop cluster and different big data analytics tools including Hive, Spark, Sqoop. Involved in importing and exporting data from local/external file system and RDMS to HDFS.
  • Designed data warehouse using Hive. Created and managed Hive tables in Hadoop.
  • Created and maintained technical documentation for launching Hadoop clusters and executing Hive queries.
  • Preparing the LLD documents, as per the Waterfall Model following by the client estimating the new Requirements preparing the plan to meet the deadline.

Environment: Oracle RAC Database, Windows XP, UNIX, PL/SQL, Shell Scripting, Informatica 9.1, Oracle 10G, TOAD, Dollar Universe, SQL Developer, Netezza, Hadoop

Confidential

Developer and Module Lead

Responsibilities:

  • Responsible for developing a system to facilitate physical settlement of commodities wifout the involvement of depositories. Played a major role in migration of back-end OS from Unix to Linux. Handled the analysis, migration of codes and testing for the same.
  • Developed a report to compare the number of trades and the profit generated in different commodity exchanges in India. Played a major role in migration of application server from Oracle forms to Java. Was involved in the analysis and initial development.
  • Responsible for various other developments and UAT for the same. Other responsibilities include the client interactions through meetings and presentations, impact analysis of proposed changes in existing components, Database management and Team management.
  • Developed an entire automated system to handle the Early Payin batch. Handled the Physical Settlement module which dealt wif physical allocation of commodities from buyer to a seller. Module lead of sales tax module which dealt wif computation of sales tax for allocated commodities.
  • Responsible for implementing the code changes in Early Payin report. Responsible for automation of the wifheld cycle using Pro*C code.

Environment: Oracle RAC Database, Windows, Linux, Unix, Pro* C, SQL, Unix Shell scripting, Oracle 10G, RCS, VSS, Oracle Forms.

Confidential

Developer and Module Lead

Responsibilities:

  • Involved in development and unit testing.

Environment: Oracle RAC Database, Windows, Unix, SQL, Unix Shell Scripting, Oracle 10G, Oracle Forms Builder Manager.

We'd love your feedback!