We provide IT Staff Augmentation Services!

Etl Lead Analyst Resume

3.00/5 (Submit Your Rating)

SUMMARY

  • 12 years of IT experience and 9+ years of experience in Data Warehousing including Requirement Analysis, Data Analysis, Application design & development and Data modeling in client/server environment.
  • Certified in N - PowerCenter 7 Mapping Designer and INS21 (Property and Liability Insurance Principles).
  • Vast experience in Finance, Marketing, Insurance and Banking Sectors.
  • Strong Domain Knowledge of Marketing, Sales, Card Services, Property and Liability Insurance.
  • Directly contributed to design and development of data management project in the areas of Database Architecture (Netezza), Data Integration/ETL (Informatica), Data Governance and build an in-house engine for Master Data Management solution.
  • Good experience in ETL tool PowerCenter/ Power Mart 6.1, 7.1, 8.6 and 9.1.
  • Worked on Slowly Changing Dimensions Type 1, Type 2 and Type 3.
  • Experience in Performance tuning of sources, mapping and sessions.
  • Working knowledge in creating Partition Points in mappings and Partitions in a session.
  • Experience in Extracting data from Flat files, Oracle 10g/9i/8i, MS SQL server 2005, Sybase IQ 15.4, DB2, Netezza 7 and Amazon RedShift.
  • Knowledge of Tableau, Business Objects, Hyperion SQR and Crystal Reporting tool.
  • Working knowledge in UNIX Shell Scripts.
  • Experience in providing Post-Implementation Production/Maintenance.
  • Possess sound knowledge of Project processes in tune with CMM Level 5 and internal Quality Audits.
  • Effective in executing multiple tasks and assignments with aggressive and demanding project schedule and team environment.
  • Strong communication and interpersonal skills with very good analytical and problem solving skills.
  • Ability to work individually and in a team environment.

TECHNICAL SKILLS

Tools: Informatica Power Center 9.x/8.x/7.x/6.x, AutoSys, Control-M, Quality Center, QTP 9.0, Sybase Power Designer, Erwin

Database Tools: Aginity Workbench, TOAD, SQL* Plus, SQL Loader

Configuration Management: Clearcase, VSS, ClearQuest, Quality Center, Heat

Programming Languages: C, C++, PL/SQL, .Net

Databases: RedShift, Netezza 7.1, Sybase 11.5, DB2, Oracle 10g/9i/8i, SQL server 2005 and MS Access, Golden Gate

Scripting: Unix/Linux Shell scripting

Operating Systems: Windows NT/95/98/2000/XP, MS-DOS, UNIX and Linux

PROFESSIONAL EXPERIENCE

Confidential

ETL Lead Analyst

Responsibilities:

  • Developed ETL jobs for RSL (Revenue Sub Ledger) feeds and involved in automating the validation of the feeds before delivering to the customer.
  • Created Scripts to generate Extract timeliness reports for SLA purpose.
  • Lead regular walkthroughs and daily stand-up meeting to discuss bottlenecks in the systems and possible solutions with the development teams as well as conducting daily production support within group including working with IDQ, Data Steward and Batch Jobs.
  • A mentor for new hires and contract team members. Responsible for bringing them up to speed on the business logic and processes and providing technical assistance.
  • Created Requirement traceability matrix from AuxDB scope with details of complete project dependencies.

Technical Environment: Informatica Power Center 9.1.6, Oracle, Sql Server, Tidal, HP ALM, Linux, FEMM, ITSM, VeriData, Golden Gate, NetCool

Confidential

Informatica Lead

Responsibilities:

  • Datamodelled star schema on high visibility and critical tasks for intergrating Market Metrics Market opportunity data with Natixis data for Sales and Marketing purpose.
  • Designed a process to pull data from Salesforce (Webservices) and Feed Aprimo with needed information for segmentation for a successful marketing campaign.
  • Involved right from design phase to build an Enterprise Data warehouse holding single version of truth for organization, having Sales, Asset and CRM data.
  • Designed and developed daily re-conciliation process to check EDW health.
  • Worked with BI team on creating views (Extracts) for Market Metrics and Daily Sales Dashboard reports.
  • Developed mappings & defined the process for creating unit test cases for BrightScope FA Representatives Daily Enrichment & Advisor Monthly Feed.
  • Had business meetings with Marketing team, understanding the business process and needs of marketing sphere.
  • Designed efficient re-usable Automated Matching Engine for MDM (Master Data Management) solution- it's flexible, easy maintainability, can add n number of rules, standardized address & firm names. This matching engine can be utilized to get duplicate data & check on null Firms CRD's etc
  • Designed logical and physical data models using Sybase Power Designer.
  • Worked on XML and Webservice Consumers transformations to pull and push data to/from time off management system and MARS MDM system.
  • Using Informatica Partitioning (Key Range and Pass through) to load data in parallel.
  • Designed mappings for slowly changing dimensions Type 2, lookup (Connected, Unconnected), update strategy, filter transformation for historical data.
  • Migrating Data from Sybase IQ to Netezza and make Informatica Code changes for the compatibility with Netezza.
  • Created Business specification document for webtrends after having elaborate discussion with web analyst who generate reports based on analytics

Technical Environment: Informatica Power Center 9.1.6, Sybase, Netezza, Amazon Redshift, AutoSys, HEAT, Linux, Salesforce CRM, Oracle CRM (Synergy)

Confidential

Informatica Lead Consultant

Responsibilities:

  • Designed logical and physical data models using ERWIN.
  • Designed mappings for slowly changing dimensions Type 2, used Stored Procedure, lookup (Connected, Unconnected), update strategy, filter transformation for historical data.
  • Worked with UNIX shell scripts for job automation and to invoke Informatica Workflows and Sessions.
  • Made the restartability very easier as the jobs involved clean-up process & optimization was made to the clean-up process.
  • Worked on XML transformations and Webservices.
  • Created various tasks, arranging related tasks in different worklets, arranged different worklets in workflow depending upon their interdependencies in workflow manager.

Technical Environment: Informatica Power Center 9.1.0, SQL server, AutoSys, HEAT, Linux

We'd love your feedback!