We provide IT Staff Augmentation Services!

Sr. Etl Architect Resume

Hoboken, NJ

SUMMARY:

  • Confidential has overall 12 years IT industry experience encompassing a wide range of skill set, roles and industry verticals.
  • Confidential is working as Master Data Management, Data Warehousing and Data Migration ETL (Informatica) Sr. ETL Architect in Confidential for more than 5 years
  • Strong working/hands on experience in INFORMATICA Product Suite (Power Center, Workflow Manager, Monitor, IDQ Developer, MDM Hub Console, Informatica Big Data Edition, Informatica Cloud), Web Methods Product Suite and databases like TERDATA, ORACLE, DB2.
  • Implemented end to end solution for Customer Data Mart using Informatica Master Data Management (MDM) to support SAP AR business (Accounts Receivables) by providing single version of truth of a customer.
  • Working knowledge of Confidential Banking Data Warehouse (BDW) Model, worked on Servicing and Originations Systems Financial Markets Back Office and settlements.
  • Basic understanding on Python as a programming language.
  • Have strong experience in building Data Governance Framework and Management strategies for better utilization of existing data. Familiarity with various Data Cleansing and Standardization procedures.
  • Have good understanding and working knowledge of Informatica MDM (Siperian) Hub, Informatica Data Director (IDD), Design of Match Rules, Merge/Un - merge operations based on business requirements, Publish layer design.
  • He has good Knowledge on Dimensional Modeling concepts, Star & Snow Flake Schema Design.
  • Excellent Communication, interpersonal and presentation skills, with ability to interact various key business and Technical stake holders across organizational hierarchies.
  • Extensively worked with large EDW systems in all functional areas including Financial Services, Investment Banking, Insurance, Health Care, Manufacturing and Media & Communication, Risk & Compliance Management.
  • He received GIS “Onsite Talent ” for outstanding contribution to client’s success for 5 consecutive Quarters in .
  • Experience with formal delivery methodologies such as SDLC, Iterative, Agile,
  • Good exposure with SQL performance Tuning, Informatica development and Teradata utilities like BTEQ, TPUMP, FASTLOAD etc.
  • Strong experience in Performance Tuning of existing Informatica Jobs, trouble shooting production jobs as part of support.
  • Strong experience with various scheduling tools such as Tidal, Autosys, Control M etc
  • Knowledge on ITIL and ITSM processes.

SKILL SET:

Business Intelligence: INFORMATICA 8.x, INFORMATICA 9.x, INFORMATICA Data Quality, Informatica MDM, BI Architecture, Confidential BDW Architecture & Data Model, Power Exchange, Confidential Initio 2.1.

Development Tools: Informatica PowerCenter, Workflow Manager, Monitor, Power Exchange, IDQ, MDM Hub Console.

Functional Modules: Media & Entertainment, Banking and Financial Services, Servicing and Originations, Mortgage, Risk, Business Objects, Business Analytic and Optimization, EDI

RDBMS: Teradata 12, Teradata 13.1.1, Oracle 9i, Oracle 8.1, MS-SQL Server 6.5/7.0, MS Access 2000, DB2 10.5

Languages: SQL, T-SQL, BTEQ scripting, Flow Language, AS400, Mainframe

O/S: Windows NT/2000 Server, HP-UX 11.1, SCO UNIX

EAI: WebMethods 6.5, WebMethods 7.1, Confidential Websphere, WPS, WID, MQ Series, SFDC

Processes: QMS (Quality Management System), ITIL

PROFESSIONAL EXPERIENCE:

Sr. ETL Architect

Confidential, Hoboken, NJ

Responsibilities:

  • Confidential for various queries from business and DATA GOVERNANCE team on all data and applications related aspects.
  • Work with vendors, development team, Data governance team and the business to deploy, maintain, and configure custom applications and build new environments as required.
  • Design and Development in configuration of landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages.
  • Create Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group.
  • Consult, Strategize, formulate setting, defining data governance and stewardship processes for MDM solutions
  • Work in the fast paced environment to analyze data quality and data flow issues into Confidential and quickly fix them programmatically.
  • Analyze the data flow requirements and develop scalable mappings for staging and loading data.
  • Develop Mappings, Mapplets using transformation as outlined by business
  • Responsible for source data analysis and Data Profiling.
  • Involved in preparing and executing unit test cases.

Environment: INFORMATICA 9.6.1 Power center, Developer (IDQ), MDM 9.7 Hotfix 7, TIDAL, Oracle 11g, Modeling, UNIX, SQL scripting.

Confidential, Roseland, NJ

ETL developer

Responsibilities:

  • Analyze the Business Requirements Documents (BRD) and conduct requirements gathering sessions for functional design.
  • Work the domain experts to create Functional Solution document (FSD) and conduct walkthru’s to ensure all the business requirements have been captured.
  • Prepare Technical Design documents (TDD) based on the BRD and FSDs to architect BI solutions.
  • Develop Mappings; Mapplets & IDQ Mapplets validations and Standardizations and Workflows using Designer and workflow Manager.
  • Conduct Code walk through and Design review sessions with the team and identify the performance bottlenecks to improve deliverables.
  • Analyze the new INFORMATICA products like B2B DX, Data Transformations, Power Exchange, IDQ and efficiently use them in current design.
  • Responsible for source data analysis and Data Profiling.
  • Implement SCD type 1 and Type 2 using DB2 10.5 Temporal table concepts.
  • Involved in preparing and executing unit test cases.
  • Handling defects.

Environment: INFORMATICA 9.5.1, IDQ, Autosys, DB2, Temporal Tables, Modeling, Unix, SQL scripting.

Confidential, Hyderabad, India

ETL Specialist

Responsibilities:

  • Analyze the data flow requirements and develop scalable mappings for staging and loading data.
  • Analyze the Data Mart requirements and accordingly prepare the Semantic solution. Work with Confidential architects to get the sign off on design.
  • Responsible for aligning DI architecture and overall design with Confidential information standards and Phase-End QA checkpoints
  • Work with Confidential business and technical heads for understand and resolve the environmental dependencies to achieve the CREDIT DATA MART (Auto) completion.
  • Develop Mappings; Mapplets & Surrogate key generation design and Workflows using Designer and workflow Manager.
  • Responsible for source data analysis and Data Profiling.
  • Utilize the extensive experience of Slowly Changing Dimensions Type 1 and Type2.
  • Involved in preparing and executing unit test cases.
  • Handling defects.
  • Provide the functional and technical guidance to Credit Data Mart - Auto Finance and Mortage Banking ETL developers.

Environment: Confidential Data warehousing Model, INFORMATICA 9.1, Confidential -Initio, TERADATA 13, BTEQ, FAST LOAD, Power Exchange 8.6,Teradata Parallel Processing (TPT), Push Down Optimizations (PDO), DB2, Oracle, Confidential Banking Data warehouse (BDW) Modeling, Unix, Control M Scheduling

Confidential

ETL developer

Responsibilities:

  • Analyze requirement to be implemented and discuss with client for further clarification.
  • Analyze the request complexity and categorize the same along with the LOE preparations
  • Allocate the work to team members and guide them towards completion.
  • Develop the Technical design document based on the business requirements.
  • Work on developing the mappings and reusable components to the requirements fulfillment.
  • Develop the Informatica Mappings and UNIX scripts.
  • Generate the extract as per BTRD and share the same with Confidential ’s Client.
  • Fixing the defects logged by the testing team during SIT and ensure the zero defect quality in UAT.
  • Coordinate with onshore and Confidential IT and Business teams to manage end to end delivery and adherence to Service Level Agreements and key Performance Indicators.
  • Responsible for recruiting project staff and functional consultants.
  • Responsible to drive transformation, automation and innovation initiatives within the team.
  • Provide directions to the team and ensure Confidential BI/DX project implements some of the best practices in delivery to improve the efficiency.
  • Responsible to allocate the work to team members and guide them towards completion.
  • Coordinate with Confidential ’s client in case of any clarifications and suggestions.

Environment: WMS scheduling, INFORMATICA, 9.1, TERADATA 13.1, Utilities, TPUMP, MULTILOAD, FAST LOAD, FAST EXPORT, UNIX, BTEQ

Confidential

ETL developer

Responsibilities:

  • Functional analysis of the system
  • End to End Interface understanding
  • Detailed interaction with client on all the details of the interfaces
  • Understanding the current architecture and proposing the solutions for improvements
  • Design specifications of the documents which get generated for the end Users.

Environment: WID, Confidential WebSphere, FROI generation mechanism.

Confidential

WebMethods Developer

Responsibilities:

  • Requirement gathering
  • Preparing the detailed design document
  • Analysis of AS IS system
  • Proposing the TO BE solution.

Environment: WebMethods, SQL, MQ Adapters, JDBC Adapters, TN Console, Developer, Unix.

Hire Now