We provide IT Staff Augmentation Services!

Etl Architect Wu Digital Analytics Resume Profile

NJ

Summary:

  • 10 years of IT experience on client-server architecture, business applications in various phases of IT projects such as analysis, design, coding, testing and supporting database and data warehouse solutions on OLAP and OLTP environment using ETL tools like Informatica Powercenter, Informatica Developer, Informatica Analyst, Oracle Data Integrator ODI , Golden Gate.
  • Experience in Business Intelligence and Reporting Tool like Tableau.
  • Experience in Data warehousing, Data Integration, Data migration projects including HDFS datasets and Hadoop Big Data querying tool such as Hive using HiveQL on Unix Editor and Beeswax Hive GUI.
  • Have good development and Performance tuning experience on Oracle Database 11g/10g/9i, Sybase ASE 15.0 and Sybase IQ, Teradata 14.0, IBM Netezza, IBM DB2.
  • Excellent experience in scripting languages like Unix Shell scripting, Teradata Bteq scripting.
  • Designed databases, Data marts, Data warehouse systems on ER Data Modeling, Dimensional Modeling Star Schema, Snowflake Schema using tools like Erwin, Aqua Data modeler, Visio, Toad.
  • Knowledge in Big data technology and Hadoop architecture.
  • Proficient in Normalization/Denormalization techniques in Relational/Dimensional database environments.
  • Played role in Project Management, Project Schedule, Project Tracking and Team Management.
  • Proficient in managing teams involved in development of user centric products and data migration across various platforms and database upgrades.
  • Executed organization design and structure, hiring, training, performance management, professional development.
  • Rich experience in programming languages like Pl/Sql, T-SQL, PostgreSQL, Hive SQL, SSIS, Pro C.
  • Knowledge in Research, Financial modelling, Statistical analysis, Operations research, Project management.
  • Implementation of Database Management Systems and Data warehouse systems for Banking, Financial and Health care clients.
  • Experience in DBA and Admin related activities using Unix, Oracle Enterprise Manager, Hue.
  • Proficient in all project methodology including Agile/scrum.

Skills:

Databases

Oracle 11g/10g/9i, MS Sql Server , Teradata 14.0, Sybase ASE 15.0, Sybase IQ, IBM Netezza, IBM DB2

ETL Tools

Informatica Powercenter 9.5.1/9.6.1/8, Informatica Developer, Informatica Analyst, Oracle data Integrator, Golden Gate, SQL Loader

Reporting Tools

Tableau 8.2

Programming Languages

UNIX Shell Scripting, Hadoop Hive SQL, Teradata BTEQ, SSIS, SQL, PL/SQL, T-SQL, C, Pro C, PostgreSQL

Database Tools

Toad 10.1.1.8, Teradata SQL Assistant, Pl/Sql Developer, Sql Developer, Aqua data studio, DBArtisan, Netezza Aginity, Hadoop Hue, SQL Plus, SQL Loader, MS SQL Server, Oracle Enterprise Manager, Database/ Performance/Query tuning TKProf, SQL Trace , Squirrel SQL Client, FileZilla, Putty, Toad for SQL Server

Scripting Languages

Unix Shell Scripting, Teradata Bteq scripting

Data Modeling Tools

Erwin 8.1, ER Studio Data Architect 8.5, Toad Data Modeler 3.4, MS Visio 2010, Aqua Data ER Modeler

GU Front-end Tools

Oracle APEX

Version Control Tools

MS Visual SourceSafe VSS , SVN, CVS, Accurev, Perforce, Confluence

Web Designing

HTML, XML

Operating systems

Unix, Windows

Job Schedulers

Autosys, Appworx, Oracle Enterprise Manager, Informatica Scheduler

QA/Testing Tools

Bugzilla, Test Case Manager, Teamtrack, JIRA, Quality Center, ResultSpace, Rally

Project Management

HR, Risk, Scope, Estimation, Organization design and structure, Hiring, Training, Performance management

Professional Experience:

Confidential

ETL Architect WU Digital Analytics

  • Leads database, ETL design processes and data warehouse appliances.
  • Involved in development/testing/tuning Informatica ETLs, Unix Shell Scripting and Hive SQLs.
  • Developed Tableau dashboards for Risk related business processes which includes Portfolio Analysis of money transfer processes, Bank declines, Approvals and marketing campaigns.
  • Database design and Data modeling of DataMart and data warehouse systems on Sql Server, Netezza, Oracle and Hadoop using Erwin and Visio.
  • Migration of data from various data sources to Hadoop warehouse system.
  • Developed automated frameworks for Audits and support alert system.
  • Assessed the impact of change requests on the enterprise architecture from a data and information perspective and worked on enhancement requests and deployment processes.
  • Created Informatica mappings/mapplets using Mapping Architect for Visio.
  • Data analysis matching requirements with reports and creating business requirement and technical specification documents.
  • Proficient in creating strategic documentation of all types in a timely fashion
  • Fluent/expert in Visio and Program/Project strategic artifacts.

Environment: Informatica Powercenter 9.5.1, Tableau 8.2, Hive SQL, SSIS, Informatica Developer 9.6.1, Hadoop, Netezza Postgre SQL, UNIX Shell Scripting, Toad data Modeler 3.4, IBM Netezza, T-SQL, MS Sql Server, Oracle 10g, Microsoft Visio 2010

Confidential

ETL Tech Lead HR Data Platform

  • Responsible for the Functional data Architecture, integration and middleware architectures, decision support architectures
  • Leads the design of database, data models, ETL processes, data warehouse applications and business intelligence solutions through the use of best practices and tools
  • Performing data analysis, matching requirements with reports, creating technical specification documents.
  • Working with business analysts on discrete technology-related business problems, formulates options including assessing their relative merits and risks, determines the best solution.
  • Provides overarching guidance and leadership on all technical and data stewardship lifecycle aspects of the sourcing of data through to the refreshing of enterprise databases with appropriate quality, modeling, change controls, and cycle time disciplines.
  • Develops strategies for data acquisitions, archive recovery, and implementation of a database.
  • Assessing the impact of change requests on the enterprise architecture from a data and information perspective
  • Developing/testing/tuning Informatica mappings, technical design documents, mapping document, plsql procedures.
  • Experience developing governance for ETL audit, balance and control
  • Developing and testing UNIX Shell Scripts.
  • Co-ordination while code deployment to production and non-production environment.

Environment : Oracle 11g, Informatica 9, Oracle 11g SQL, Pl/sql, UNIX, Toad data Modeler 3.4, TOAD 10.1.1.8, Informatica Debugger, Microsoft Visio 2010, Filezilla, Putty, Microsoft SQL Server, Unix shell Scripting, Toad for SQL server

Confidential

ETL Tech Lead IFS Data Platform

  • Leads the design of database, data models, ETL processes, data warehouse applications and business intelligence solutions through the use of best practices and tools
  • Performing data analysis, matching requirements with reports, creating technical specification documents.
  • Status discussion with various stakeholders.
  • Performing data analysis, matching requirements with reports, creating technical specification documents.
  • Interacting with business users end analysts in order to formulate data model as per requirements using ERwin data modeler.
  • Working closely with the DBAs to implement data model and translate it to physical database design
  • Data validation for data flowing from upstream systems.
  • Developing/testing/tuning Informatica mappings, technical design documents, mapping document, plsql procedures.
  • Developing and testing UNIX Shell Scripts.
  • Review ETL design and Informatica mappings, Unit test plan documents.
  • Co-ordination while code deployment to production and non-production environment.
  • Defect fixing and trouble shooting.

Environment : Oracle 11g, Informatica 9, Oracle 11g SQL, Pl/sql, UNIX, Data Mart, Windows XP, Toad data Modeler 3.4, TOAD 10.1.1.8, Microsoft Visio 2010, Filezilla, Putty, Microsoft SQL Server, Unix shell Scripting, Toad for SQL server

Confidential

ETL Architect

  • Develops architecture strategies, documents and maintains Architecture Roadmap for the Data Warehouse
  • Responsible for working on medium to high architectural impact projects, creating Conceptual Architecture and High Level Design documentation and recommending Best Practices.
  • Creates logical, physical and dimensional data models using Erwin
  • Experience with ETL design and developing architecture for Data Marts
  • Proficient in creating strategic documentation of all types in a timely fashion, fluent/expert in Visio and Program/Project strategic artifacts
  • Responsible for reviewing and approving low architectural impact designs and directing implementation of the architecture
  • Conducts complex technology and data assessments for data warehouse architecture and participates in ongoing releases, directing implementation of the architecture
  • Acts as a lead in component architecture and provides in-depth technical and systems consultation to ongoing releases and technical management to ensure alignment with the Architecture.
  • Acts as expert technical resource to Data Analysts and development staff in the development, testing, and implementation process.
  • Data validation for data flowing from upstream systems.
  • Developing/testing/tuning Informatica mappings, Bteq scripts, plsql code
  • Developing and testing UNIX Shell Scripts.
  • Review ETL design and code prior to delivery.
  • Co-ordination while code deployment to production and non-production environment.
  • Defect fixing and trouble shooting.

Environment : Oracle 11g,Teradata 14.0, Informatica 9, Oracle 11g SQL, Bteq Teradata Sql, Model N, Pl/sql, UNIX, Data Mart, Windows XP, Toad data Modeler 3.4, TOAD 10.1.1.8, Microsoft Visio 2010, MS Office, Filezilla,Aqua data studio, Teradata SQL Assistant, Bteq Scripting.

Confidential

Senior ETL developer

  • Working closely with the management to formulate and track project plan.
  • Discussion with various stakeholders at offshore and client teams
  • Followed Sapient approach Agile methodology to track the project status and deliverables
  • Estimating and planning resources based on Sapient approach
  • Database designing/Modeling for AA application using Erwin, Aqua Data Studio
  • Performing Technical Analysis and creating functional requirement document
  • Analyzing the requirement and formulating solutions.
  • Verifying data quality after extracting and loading data from external feed using integration service by Informatica.
  • Data validation for data flowing from upstream systems.
  • Review Informatica ETL design and code prior to delivery.
  • Analyzing the existing T-SQL programs and replicate the logic in PL/SQL.
  • Developing/testing/tuning T-SQL, PL/SQL code.
  • Developing and testing UNIX Shell Scripts.
  • SQL and PL/SQL Performance Tuning analyzing query plans query tuning for SQL scripts by using tools such as Explain Plan, TKProf, SQL Trace utilities.
  • Leading a team for 3 members at onsite and 15 resources at offshore.
  • Co-ordination while code deployment to QA and production environment.
  • Defect fixing and trouble shooting.

Environment : Oracle, Sybase ASE, Sybase IQ, Informatica 8.6, Oracle 11g, UNIX shell scripting, Oracle Pl/Sql, Sybase T-SQL, Oracle PL/SQL, Golden Gate, Autosys, Toad data Modeler 3.4, SQL Loader, TOAD 10.1.1.8, XML, Microsoft Visio 2010, Data Mart, Putty, Clearcase, DBArtisan.

Confidential

Senior ETL developer

  • Followed Sapient Approach SA Agile methodology to track project status and iterations
  • Status discussion with offshore and client teams
  • Database designing/Modeling for legal entity database using Erwin, Aqua Data Studio
  • Performing Technical Analysis and creating Technical Design Document.
  • Analyzing the requirement and formulating solutions.
  • Extracting and Loading data from external feed using integration service by Informatica.
  • Data migration to migrate data from databases like Oracle, Sybase ASE to Oracle and Sybase IQ environments for generating reports and for auditing purposes
  • Data validation for data flowing from upstream systems.
  • Review Informatica ETL design and code prior to delivery.
  • Analyzing the existing T-SQL programs and replicate the logic in PL/SQL.
  • Developing/testing/tuning T-SQL, PL/SQL code.
  • Developing and testing UNIX Shell Scripts.
  • SQL and PL/SQL Performance Tuning analyzing query plans query tuning for SQL scripts by using tools such as Explain Plan, TKProf, SQL Trace utilities.
  • Leading a team for 3 members at client location and 14 resources at offshore.
  • Co-ordination while code deployment to QA and production environment.
  • Defect fixing and trouble shooting.

Environment : Oracle, Sybase ASE 15.0.3, Sybase IQ, Informatica, Sybase T-SQL, Oracle PL/SQL, Golden Gate, Oracle 11g, Aqua data studio, Accurev, Java, UNIX, Toad data Modeler 3.4, SQL Loader, TOAD 10.1.1.8, JIRA, Data Mart, Unix shell scripting, .NET Framework, XML, Microsoft Visio 2010, Aqua data modeler, DBArtisan, Putty

Confidential

Senior ETL Developer

  • Analyzing the requirement and assigning it to team members.
  • Performing Technical Analysis and creating Technical Design TD Document.
  • Interacting with business users end analysts in order to formulate data model as per requirements using ERwin data modeler.
  • Review Informatica ETL design and code prior to delivery.
  • Developing and Testing T-SQL programs.
  • Developing/testing/tuning PL/SQL code.
  • Developing and testing UNIX Shell Scripts.
  • Database Designing/Modeling.
  • Designing/Developing Informatica ETL Flow.
  • SQL and PL/SQL Performance Tuning analyzing query plans query tuning for SQL scripts by using tools such as Explain Plan, TKProf, SQL Trace utilities.
  • Review the design and code prior to delivery.
  • Co-ordination while code deployment to QA and production environment.
  • Defect fixing and trouble shooting.

Environment : Oracle, Sybase ASE 15.0.3, Sybase IQ, Informatica, PL/SQL, Sybase ASE, Sybase IQ, T-SQL, Data Mart, Unix shell scripting, Accurev, Aqua Data Studio, DBArtisan, Erwin, Aqua Data Modeler, Putty, Golden Gate, JIRA, Toad, Java, XML

Confidential

Senior ETL Developer

  • Developed complex PRICING functionality module involving advanced features of oracle 10g
  • Prepared Story high level of tasks Dashboard lists, High Level planning and LLP tasks
  • Performed as a Track lead for various teams like VaR Reporting, Performance, Data Warehousing team
  • Performed as a DBA of the project and involved in maintenance of multiple databases
  • Performed as a Technical SME and held responsibility of Deliverables sent to clients
  • Involved in internal Client code reviews and followed strictly the Sapient SA3 quality process
  • Analyzing the requirement and assigning it to team members.
  • SQL and PL/SQL Performance Tuning analyzing query plans query tuning for SQL scripts by using tools such as Explain Plan, TKProf, SQL Trace utilities.
  • Defect fixing and trouble shooting.
  • Database designing/Modeling for few modules.
  • Help other teams in the business domain

Environment : Oracle 10g, Microsoft SQL Server, Oracle PL/SQL, Sybase T-SQL, SSIS, Data Modeling, Toad Data Modeler, Oracle Enterprise Manager, Unix Shell Scripting, Visual Studio Safe, Microsoft Visual Studio, Data Mart, Bugzilla, TKProf, Performance tuning, ERwin

Confidential

ETL developer

  • Working closely with the management to formulate and track project plan.
  • Status discussion with various stakeholders.
  • Performing Technical Analysis and creating Technical Design TD Document.
  • Performing Data Analysis.
  • Analyzing the requirement and formulating solutions.
  • Extracting and Loading data from various source systems using integration service by Informatica.
  • Designing ETL flow for the Data Mart.
  • Data validation for data flowing from upstream systems.
  • Developing/testing/tuning PL/SQL code.
  • Developing and testing UNIX Shell Scripts.
  • SQL and PL/SQL Performance Tuning analyzing query plans query tuning for SQL scripts by using tools such as Explain Plan, TKProf, SQL Trace utilities.
  • Review ETL design and code prior to delivery.
  • Defect fixing and trouble shooting

Environment : Oracle 10g, Oracle PL/SQL, Informatica, Java, Oracle XML technologies, SQL Loader, Oracle data Integrator, Unix shell scripting, CVS, Putty, Toad data modeler, Data Mart

Hire Now