We provide IT Staff Augmentation Services!

Etl Developer (informatica, Tsql, Pl/sql) Resume

SUMMARY:

  • Having 10 years of Global IT experience in Business partnering, Requirement Analysis, Design, Planning, Development, Testing, Implementation & Supporting of Enterprise Data Warehouses, Data Marts & Operations Data Stores.
  • Comprehensive knowledge on e2e Data Solutions with hands on experience in multiple projects and platforms built at Confidential for Marketing, Sales, Master Data Management, Software & Information management domains.
  • Experienced in analyzing data from different sources from profiling, quality & definition perspectives and building data solutions for Operational, Analytical and Reporting systems.
  • Proficient with Dimensional Data modeling, Star Schema / Snowflakes Schema, Dimension, x - ref & Fact tables.
  • Experienced with Integration of various data sources like Oracle, SQL Server, DB2, Vertica, SAP Systems, Web Services, JMS, Excel, XML and Flat Files using ETL Tools like Informatica PowerCenter, SSIS and custom scripting.
  • Proficient in writing complex SQL Queries, Stored Procedures, Functions with Query Optimization techniques.
  • Proficient in developing complex mappings for ETL Jobs and shell/batch scripts for pre/post ETL Jobs.
  • Experienced with reporting & analytical tools include Business Objects, SSAS and HP Operations Analytics Tool.
  • Worked with different scheduling tools like Tidal, AutoSys, Informatica Scheduler, Win batch scheduling & Cron jobs.
  • Informatica PowerCenter Administration skills on a huge shared services platform and familiar with Oracle DBA tasks.
  • Experienced in configuring SFTP/SCP in both Windows & UNIX environments, familiar with CFS, NFS usage & operational knowledge on renewing SSL certificates.
  • Well versed with monitoring & automation suite of technologies to address infrastructure & applications operational issues both reactively & proactively and familiar with continuous integration modules and DevOps practices.
  • Documentation on Detailed Technical Design, Migration process, Test cases and updating Application Runbooks.
  • Conversant with e2e event lifecycle and well versed with ITIL practices like Configuration, Release/Change, Incident/Major Incident, Problem management & continuous service improvement areas.
  • Detail oriented, passionate to learn about new domains while providing a value add with experience.

TECHNICAL SKILLS:

Operating Systems: HP-UX (11.31, 11.23), Linux (RHEL 6x, 5x), Sun Solaris, Windows

Databases: Oracle (11g, 10g, 9i), MS SQL (2012, 2008, 2005), DB2, Vertica, Sybase, Postgres, MongoDB

Programming: SQL (ANSI, TSQL), PL/SQL, Shell & Windows Batch Scripting

Clustering: Veritas, HP Serviceguard

Cloud Computing: HP Private Cloud

ETL Tools: Informatica PowerCenter (9.6.1, 9.5.1, 8.6, 7.1), SSIS (2012, 2008)

Reporting & Analytics: Business Objects, SSAS, HP Operations Analytics

Scheduling Tools: Tidal, AutoSys, Informatica Scheduler, Windows batch scheduler & Crontab

Version Control: Subversion, GitHub

Monitoring Tools: HP Operations Manager, OMi, SiteScope, APM

Automation Tools: HP Operations Orchestration

Service Management: HPSC/HPSM

Handson Experience: Erwin, Informatica Identity Resolution (MDM Tool), WebLogic, Tomcat, Apache, IIS, Cognos TM1, CleverPath, Visual Studio, DB Client Tools

PROFESSIONAL EXPERIENCE:

Confidential

ETL Developer (Informatica, TSQL, PL/SQL)

Responsibilities:

  • Interacting with Infrastructure, Functional Architects/Consultants, Partner Application Teams and Business teams to understand project requirements, use cases and business rules.
  • Involved in Data Analysis, Data Model Analysis, Impact Analysis and preparation of High Level Design documents
  • Responsible for writing Detailed Design Documents and Unit Test documents.
  • Worked on multiple data sources like Oracle, MS SQL, Vertica, XML, Web Services, Salesforce, Excel and Flat Files.
  • Experienced with slowly changing dimensions, maintaining history data and Parameterization Techniques.
  • Experienced in developing reconciliation jobs, data quality validations and metadata reports.
  • Extensively used PowerCenter Client Tools for developing mappings, workflows, reusable objects, parameters and variables. Experienced with Debugging and Performance Tuning at Target/Source/Mapping/Session/System level.
  • Make use of transformations like Source Qualifier, Application Source Qualifier, XML, Expression, Filter, Router, Normalizer, Sorter, Sequence Generator, Update Strategy, Joiner, Aggregator, Connected/Unconnected Lookup, Stored Procedure & Target overrides.
  • Make use of tasks like Sessions, Command Task, Decision Task, Event Wait, Email and partitioning techniques.
  • Created Shell Scripts for calling Informatica Workflows and pre/post ETL Jobs.
  • Experienced in writing complex SQL queries & Stored Procedures, Functions (TSQL, PL/SQL) & Performance Tuning.
  • Experienced in designing data transformation services packages using SQL Server Integration Services.
  • Having Operational knowledge on Database Administrations skills like export/import, reviewing AWR reports.
  • Scheduled Jobs on Tidal Enterprise Scheduler, well versed with creating variables, different types of dependencies, alerts on failures/long running/agent issues etc.
  • Addressing any pre/post production issues/defects by coordinating with QA and Business Teams.
  • Working with operations team production issues, identifying automation opportunities and well conversant with ITIL Processes (Incident, Major Incident, Release, Change & Problem Management Areas).
  • Ensuring support runbooks are up to date and keen to share knowledge.
  • HP Separation Management Office (HPI/HPE): Actively worked with designated work stream leads to identify right disposition strategy and therefore providing a logical/physical separation activities for HPQ applications.
  • Also worked on an automation project using HPE Monitoring & Automation suite of products to build a technological solution to address infrastructure & application issues at event level that allows ITIO to analyze events, predict a recovery action based on history and execute the recovery actions with or without human intervention.

Environment: HP-UX (11.31), Red Hat Enterprise Linux (6.7), Windows (2012, 2008), Oracle 11g, MS SQL (2012, 2008), Vertica 7.1, Postgres, Salesforce, Web Services, XML, Flat Files, Informatica PowerCenter (9.6.1, 9.5.1), SSIS, Tidal, Business Objects, SSAS, HPE OpsBridge, HPSM, Weblogic, Tomcat, Apache, IIS, SVN, GitHub, ALM & HPE Private Cloud.

Confidential

Informatica PowerCenter Developer / Administrator

Responsibilities:

  • Actively involved in upgrading Informatica PowerCenter from Version 8.6.1 to 9.5.1 and later to 9.6.1.
  • Experienced in creating Domains, Repositories, Repository Service, Integration Service, Web Services Hub, PowerExchange Adapters for Salesforce, SAP R/3 and JMS (Real-time).
  • Implemented Informatica services on grid for Highly Availability & Load Distribution purposes.
  • Experienced in Configuring Oracle, ODBC drivers for different databases like Neoview, Seaquest and Vertica.
  • Closely worked with the DBAs & System Admins for rolling out the upgrades and hotfixes.
  • Worked with Informatica technical support on several Informatica related technical issues and resolved them.
  • Proposed & Implemented Automated Disaster Recovery Strategies for restoring business continuity during outages.
  • Managed Users, Groups, Folders, Privileges and Deployment groups, OS Profiles.
  • Involved in preparing migration documents to move the mappings from development to production repositories.
  • Provided consulting (Technical & Process) to various projects and helped them migrate to 9.5 platforms.
  • Carried out Code migration activities across repositories and environments and creation of jail areas, SSH setup for each project hosted on platform, & fulfilling additional tenant requirements like GnuPG, Curl, base64, Samba, 7z etc.
  • Implemented Automated code deployment between environment using shell scripts
  • Performing regular maintenance activities like service restoration, troubleshooting application & platform issues and quarterly maintenance of cleaning up metadata tables (logging data as recommended by Vendor).
  • Extensively used PowerCenter Client Tools for developing mappings, workflows, reusable objects, parameters and variables. Experienced with Debugging and Performance Tuning at Target/Source/Mapping/Session/System level.
  • Make use of transformations like Source Qualifier, Application Source Qualifier, XML, Expression, Filter, Router, Normalizer, Sorter, Sequence Generator, Update Strategy, Joiner, Aggregator, Connected/Unconnected Lookup, Stored Procedure & Target overrides.
  • Make use of tasks like Sessions, Command Task, Decision Task, Event Wait, Email and partitioning techniques.
  • Experienced in writing complex SQL queries & Stored Procedures, Functions (TSQL, PL/SQL) & Performance Tuning.
  • Created Shell Scripts for calling Informatica Workflows and pre/post ETL Jobs.
  • Providing 24/7 support and ensuring monitors are in place, support runbooks are up to date. Keen to share the knowledge to others.

Environment: HP-UX (11.31, 11.23), Red Hat Enterprise Linux (6x), Windows (2012, 2008), Oracle (11g, 10g), DB2MS SQL (2012, 2008), DB2, Informatica PowerCenter (9.6.1, 9.5.1, 8.6.1), SSIS, Tidal, HPSM, Business Objects, SSASHP ServiceGuard, Veritas, IVM Guests and HP Private Cloud.

Confidential

ETL Developer (Informatica, PL/SQL)

Responsibilities:

  • Understand migration strategy and guidelines from onsite lead and responsible for writing detailed migration docs.
  • Rewriting Informatica Objects for migrating existing Informatica/Sybase code to Informatica/Oracle code.
  • Rewriting Stored Procedures written in Sybase to Oracle
  • Creating new mappings/workflows in Informatica for additional client requirements (enhancements)
  • Identifying the dependencies b/w Source Systems and creating Autosys JIL Templates, preparing metadata queries to automate the Jobs & Test plans.
  • Application testing in SIT (Pre ETL/ETL/Post ETL Jobs) to reconcile data existing & new schemas.

Confidential

ETL Developer (Informatica, PL/SQL)

Responsibilities:

  • Involving in Project meetings to understand business requirements and responsible for writing detailed Design Documents and Unit Test documents.
  • Developing Informatica Objects like Mappings/Workflows, Stored Procedures and shell scripts for pre/post ETL jobs.
  • Experienced with slowly changing dimensions, maintaining history data and Parameterization Techniques.
  • Informatica Administrator related roles like MTI, MTP & Service Restoration on version 7.1.2
  • Troubleshoot production issues and work on data quality issues.
  • Also worked on Legacy Asset Retirement Activities such as “Archiving the Source code, Server/App Data & preparing restoration plan”.

Hire Now