We provide IT Staff Augmentation Services!

Informatica/etl Developer  Resume

3.00/5 (Submit Your Rating)

Worldwide, MD

Hire Now

SUMMARY:

  • Develop complex Informatica mappings to load the data from various sources using different transformations like source qualifier, connected and unconnected lookup, update Strategy, expression, aggregator, joiner, filter, normalizer, rank and router.
  • Excellent in writing and optimizing SQL queries using Toad, Oracle and SQL Server 2008.
  • Strong experience in generating successful analysis, data manipulation with Excel, Pivot Tables to extrapolate business needs and produce reports.
  • An excellent team player with business users, program managers, and team leads, architects and other team members maintaining healthy work environment.

TECHNICAL SKILLS:

  • Agile, Scrum and Waterfall
  • Gap Analysis; Requirement Gathering
  • Microsoft Office
  • Access, Word, Excel,
  • PowerPoint, Project, Outlook
  • Data Management
  • SQL Script Generation and SQL Querying
  • Structured Query Language(SQL)
  • Microsoft SQL, Oracle, TOAD, MYSQL
  • Operating Systems - Windows 7, Windows 8, Windows XP
  • Extraction Transformation and Loading

PROFESSIONAL EXPERIENCE:

Confidential, MD

Informatica/ETL Developer

Responsibilities:

  • Successfully creates, manages relational databases and performs data cleansing using SQL scripts.
  • Involve in all phases of SDLC from Requirement gathering, Design, Development, Testing, Production, User training and support for production environment.
  • Successfully creates new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
  • Develop the mappings using needed Transformations in Informatica tool according to technical specifications.
  • Successfully creates complex mappings that involve implementation of Business Logic to load data in to staging area.
  • Effectively creates Worklets, Workflow and Tasks to schedule the loads at required frequency using Workflow Manager.
  • Also involve in migration/conversion of ETL processes from development to production.
  • Create reusable email tasks in Workflow manager for process exception handling.
  • Gather Business requirements & specifications for the data warehouse design. Translate the user inputs into ETL design docs.
  • Optimizing performance tuning at source, target, mapping and session level.
  • Successfully implements Slowly Changing Dimension tables (SCD) methodology creating access to client’s full account history.
  • Developed various Mappings with the collection of all Sources, Targets, and Transformations using Informatica Designer
  • Developed Mappings using Transformations like Expression, Filter, Joiner and Lookups for better data messaging and to migrate clean and consistent data
  • Extracted data from various sources across the organization (Oracle, SQL Server and Flat files) and loading into staging area
  • Created and scheduled Sessions and Batch Process based on demand, run on time, or run only once using Informatica Workflow Manager and monitoring the data loads using the Workflow Monitor
  • Participated in Testing and performance tuning by identifying bottlenecks in mapping logic and resolving them, setting cache values and creating partitions for parallel processing of data.
Confidential

I.T. Support Analyst|

Responsibilities:

  • PC hardware installation, configuration, maintenance & upgrades.
  • Operating System installation, maintenance & upgrades
  • Router, Firewall, Cable Modem, Wi-Fi installation and configuration
  • Application Software installations and maintenance.
  • Antivirus, Spyware, and Spam protection
  • PC support including system tuning and optimization.
  • Network, Remote Access, and Peripherals setup and support.
  • General desktop PC and server support.
Confidential, Cheverly, MD

Warehouse Supervisor

Responsibilities:

  • Communicated verbally and in writing with warehouse personnel, managers and customers to facilitate the fulfillment of orders
  • Collected production data, organized it and generated management and performance reports to gauge warehouse efficiency and productivity
  • Delegated tasks to personnel to keep ordered timelines and production requirements
  • Trained workers in warehouse policies and procedures
  • Coordinated and led staff and interdepartmental meetings
  • Created and disseminated customer surveys to gauge their satisfaction levels
  • Oversaw the conversion of new client accounts
  • Assembled detailed reports on customer satisfaction, needs, challenges and requests

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship