We provide IT Staff Augmentation Services!

Sr Etl Developer Resume

SUMMARY

  • 16 years of experience in system analysis and design in all phases of SDLC with emphasis on Data Warehousing and Informatica as ETL tool well versed in ETL and ELT process
  • Domain work experience in US Retail Banking, Auto Insurance, Retail, Telecom, Travel and Tourism and Manufacturing Industry worked with Major Client
  • 10 years of experience working with Informatica PowerCenter ETL tool
  • 1 - year experience in Informatica Intelligent Cloud Services (IICS) and Informatica Cloud real time event-based services also completed IICS 101/201
  • 1+ Year of experience in Informatica Analyst and Informatica Data quality (IDQ) for profiling and cleansing
  • 2 years Informatica B2B data transformation studio
  • 2 year of experience using Informatica Power Exchange
  • 3 years of experience using XML technologies like XML, XSD, XSLT, XQuery also familiar with JSON
  • Hands on experience in performance tuning of mapping, identifying and resolving performance bottlenecks in Informatica mappings and sessions
  • 4 years of experience working with Teradata EDW system using tools fastload, fastexport, Tpump, Bteq scripts
  • 4+ years hands on experience with Relational and Dimensional modeling using CA-ERWIN, designed conceptual, logical and physical modelling
  • Developed PL SQL packages and stored procedure
  • 24/7 production support experience using Remedy and ITIL framework
  • Developed and enforced ETL development standards and best practices
  • Training and mentoring junior developers
  • Experience in interacting with cross functional teams
  • Lead Agile Scrum Meetings

TECHNICAL SKILLS

ETL tools: Informatica PowerCenter 10x, Informatica Power Exchange, Informatica B2B Data transformation studio, Microsoft SSIS, SSRS, Microgen Aptitude Studio, Oracle Data Integrator (ODI), EDQ Experian Pandora Data Quality tool, Address Validation tool

Database: Oracle 12c, DB2 10.1, MS SQL Server, Teradata 15 (Fastload, Mload, Tpump, Bteq queries), MySQL, Vertica 9.x

Languages: Java, XML, XSLT, XQuery, SQL, PL/SQL, T-SQL, python, shell scripting

Version Control and Release Management: Subversion, Git

Business Intelligence tools: Crystal Reports IX, Cognos 10, Power BI

Job Scheduler: ESP, Control-M and Autosys

Mainframe technologies: COBOL, JCL, VSAM, DB2, TSO/ISPF

Tools: Toad, SQL Navigator, DB Visualizer, SQL Developer, Notepad++, Ultra edit

Operating system: Red hat, Solaris, UNIX, Windows 10

Cloud technologies: Amazon Web Service, Digital Ocean

PROFESSIONAL EXPERIENCE

Sr ETL Developer

Confidential

Responsibilities:

  • Designed and Developed ETL solution for change data capture as part of clinical audit process, migrated informatica mappings from on-premise to oracle cloud environment, developed and tuned informatica mappings, executed test cases in QA environment as per business requirement

ETL Architect

Confidential

Responsibilities:

  • Trained in Data Quality tool Experian Pandora 5.8, developed strategies to profile, clean and map old legacy data to the new CARS system, profiled legacy cal-access data using pandora tools to find data anomalies, developed data quality rules to clean the data, created source to target mapping to map data from old legacy system to new system, used pandora batch address verification solution to clean 20 million address records and standardize using USPS format, developed etl solution using Microsoft SSIS.

ETL Architect

Confidential

Responsibilities:

  • Designed and developed ETL solution for Confidential MDM and Enterprise Datawarehouse, developed and tuned informatica mapping, provided production support, resolved production tickets and maintenance tasks, created reports for adhoc request from Confidential marketing team

ETL Lead

Confidential

Responsibilities:

  • Confidential Unified Data Model is representation of key business area for B2B, CUSTOMER, BILLING, POINT OF SALE and other DATA Products, Designed and developed ETL solution using Informatica PowerCenter to load data into UDM Data warehouse, developed PowerCenter mapping to load reference and transactional data into staging area to enrich and standardize, created two data marts each for wireline and wireless business area for revenue recognition regulatory project, developed ETL pipelines for revenue recognition system to support regulatory project for Confidential, modeled a data processing layer in Oracle 12c, created data pipelines to load data from Teradata EDW, Confidential billing systems, PeopleSoft ledger, wSAP system to OLTP and OLAP system, applied transformation to enrich and standardize the data and prepared reports for user consumption, optimized performance for mappings and tuned SQL queries, worked with data analyst to understand and facilitate the requirement, worked on ERD and dimensional modelling, developed conceptual, logical and physical data models, profiled and cleansed data using Informatica Analyst and Informatica data quality tool IDQ, managed a team of 5 ETL resource, delegating work on agile environment, conducting peer code reviews, overseeing the work of junior ETL developers

Hire Now