We provide IT Staff Augmentation Services!

Etl Developer Resume

Coppell, TexaS

SUMMARY:

  • To contribute positively towards the realization of the goals and objectives of an organization.
  • A self starter, proactive and highly motivated.
  • Ability to maintain professional etiquette under pressure.
  • Proficient in use of Microsoft word, power point.
  • Proficient in the use of Informatica, tableau, SQL, Oracle, Linux, SSRS, Power BL.
  • Over Five Years of IT experience with professional work experience in Data Warehouse/Data Mart design, System analysis, development, Database design, SQL, PL/SQL programming. Extensive experience in Data Warehousing, ETL (Extraction, Transformation, Loading) using Informatica5.x/6.x/7.x
  • Expertise in implementing complex Business rules by creating robust mappings, mapplets, and reusable transformations using Informatica Power Center and Power Mart.
  • Working Knowledge on different data sources as Flat Files, Oracle, SQL Server, XML and Excel.
  • Experience with complex mappings using Filter, Aggregator, Expression, Router, Lookup, Update Strategy, Sequence generator, Rank.
  • Experience in creating Sessions, Workflows, and Worklet by using the Workflow Manager tools like Task Developer, Worklet and Workflow Designer.
  • Excellent in creating the map, assigning workflow, testing the flow and monitoring the job. gain troubleshooting information about data and error conditions
  • Experience in optimizing query performance, session performance and fine tuning the mappings for optimum performance
  • Experience with pre - session and post-session SQL commands to drop indexes on the target before session runs, and then recreate them when the session completes.
  • Knowledge of full life cycle development for building a Data Warehouse.
  • Excellent problem solving skills with a strong technical background and good interpersonal skills. Quick learner and excellent team player, ability to meet tight deadlines and work under pressure

TECHNICAL SKILLS:

ETL Tools: Informatica (Power Center 9.6.1)

RDBMS: Oracle 11g/10g/9i. SQL, PL/SQL, Stored Procedure, Functions

SQL: Server 2019/2016/2014/2012

Reporting Tool: Power BI,Tableau, Tableau Prep.

WORK EXPERIENCE:

Confidential, COPPELL, TEXAS

ETL Developer

Responsibilities:

  • Primarily responsible to convert business requirements into system design.
  • Further implemented system model in Informatica, comprehensively using the functionality of the tool.
  • Used ETL to standardize data from various sources and load into Data Stage area, which was in Oracle
  • Worked on Informatica Power Center tool - Source Analyzer, Warehouse designer, Mapping and Mapplet Designer, Transformations, Informatica Repository Manager and Informatica Workflow Manager.
  • Extensively used ETL to load data from wide range of source such as flat files, XML to Oracle
  • Extensively used PL/SQL Procedures/Functions to build business rules.
  • Informatica Designer tools were used to design the source definition, target definition and transformations to build mappings.
  • Designed and Developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (Fact/Summary) data identified by dimensions using Informatica Power Center tool.
  • Created the mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookup, Router, Filter, and Update Strategy.
  • Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
  • Monitored Workflows and Sessions using Workflow Monitor
  • Extensively worked in the performance tuning of programs, ETL procedures and processes.
  • Precise Documentation was done for all mappings and workflows.
  • Used Debugger in troubleshooting the existing mappings

Confidential

Data Analyst /Developer

Responsibilities:

  • Develop and maintain SQL Queries from multiple data sources to support the business.
  • Gather data, analyse data, develop and build Tableau reports for upper management for decision making.
  • Work closely with the IT Manager to develop dashboard reports, Drilldowns, Drill through.
  • Use SQL to analyse, query, sort and manipulate data according to defined business rules and procedures.
  • Import multiple daily and weekly csv files using Bulk Insert SQL command into Tables to generate reports
  • Create and schedule multiple jobs to load data from various source that are received daily in other to develop reports for upper management.
  • Wrote Queries to develop new, ad-hoc and modified existing reports in SSRS and Excel using charts, graphs, tables and matrices.

Confidential

Admin Assistant

Responsibilities:

  • Produce and distribute correspondence memos, letters, faxes and forms.
  • Assist in the preparation of regularly scheduled reports.
  • Submit and reconcile expense reports.
  • Develop and maintain a filing system.
  • Research and create presentations.
  • Develop administrative staff by providing information, educational opportunities and experiential growth opportunities.
  • Prepare and monitor invoices.
  • Contribute to team effort by accomplishing related results as needed.
  • Develop and updates administrative systems to make them more efficient.
  • Resolve administrative problems.
  • Oversee and supervised the work of junior staff.
  • Handle sensitive information in confidential manner
  • Maintain computer and manual filing system.

Hire Now