We provide IT Staff Augmentation Services!

Etl Architect Resume

SUMMARY

  • Provide technical expertise throughout all phases of the system data integration life cycle (including requirements, analysis, design, implementation, resource deployment, performance tuning, testing, and support) on Waterfall and Agile platforms.
  • Collect requirements by interviewing business users, analyze source systems, database and develop specification documents.
  • Estimate the time and scope of specific business intelligence projects (e.g. Business Performance Reporting, Dashboards, Data Analytics, Visualizations, Score cards, Data sourcing, Data Profiling etc.);
  • Design, Develop, Test, and Support Business Intelligence semantic layer, building blocks, reports, dashboards using industry standard tools such as Cognos, MicroStrategy, SQL, SQL Server Integration Services (SSIS), Tableau, etc.
  • Analyze test results and performance reports to verify software efficiency and eliminate programming errors to ensure uninterrupted data reporting.
  • Writing, updating, and maintaining complex computer software and data integration program packages for Business Intelligence Systems, utilizing programming languages.
  • Integrating data from various sources to make it accessible and retrievable across a broad range of user interfaces by end users.
  • Developing, testing and supporting protocols for data quality, data integration, data management, data warehousing (in Kimball and Inmon styles), and data extract - transform-load, utilizing specialized industry tools (e.g., SSIS, Informatica, MicroStrategy, DB2 SQL, Oracle PL-SQL etc.) to ensure an accurate data gathering and reporting environment;
  • Providing Administration for Business Intelligence Systems infrastructure.
  • Provide Level 2 and 3 support for the application using - MicroStrategy, Linux, command scripts Informatica, Oracle, SSIS, Talend, DB2 to build Extract Transform Load (ETL) routines, Web services.
  • Resolve production support incidents, participate in Change Management process, Knowledgebase maintenance, release deployments.
  • Created and executed project work plans and revised plans as appropriate to meet the ever-changing business needs and requirements. Used formal SDLC project methodology
  • Analyzing test results and writing performance reports to verify software efficiency and eliminate programming errors to ensure uninterrupted data analysis and integration.
  • Learning and applying the latest technologies to deliver the highest-quality products and services.
  • Collaborating with all computer professionals to maximize resource development, knowledge base development, and training and performance management; and
  • Managing relationships with clients and providing on-going software support to clients.
  • Expertise in installation, design, development, administration and testing of data integration solutions built with Informatica products suite.
  • Extensively worked on Informatica designer components - Source analyzer, Transformation developer, Mapplet and Mapping Designer.
  • Hands on experience with complex mappings from varied transformation logic like connected and unconnected Lookups, Router, Aggregator, Joiner, Update Strategy etc.
  • Experience in creating UNIX shell scripts to automate processes.
  • Created Documentation (Runbook, Technical Design Document and Low-Level Design Document) for supporting the Application using Microsoft Word, Visio.
  • Proficient in writing complex SQL queries using complex SQL features such as correlated subqueries, hierarchical queries, analytical queries etc.
  • Good Knowledge in Dimensional Modeling, Star Schema & Snowflake Schema. Very good knowledge on the DWH Architecture (end to end flow: ETL to Reporting)
  • Expertise in MicroStrategy Desktop Features includes integrating of MicroStrategy reports with objects includes Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups and Intelligent Cubes.
  • Extensively worked on designing schema objects includes creation of Facts, Attributes, Hierarchies, Logical Views and Transformations

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10,9.1 (Designer, Workflow Manager, Workflow Monitor, Repository manager), SSIS

Databases: DB2 v8.1/8.7, Oracle 11g,12c MS SQL Server 2012/2017, MySQL, Sybase

Data Modeling: Erwin, MS Visio

OLAP Tools: MicroStrategy 9x/11.0

Database Tools: Toad, SQL Developer, Squirrel

Languages: SQL, PL/SQL, UNIX Shell scripting

Process Modelling: MS Visio

Version Control: Team Foundation Server

Release Management: Jira and Confluence

Other Tools: HP Service Center, HP Service Manager, Service Now ticketing and Google Cloud Computing, GlobalScape Enhanced File Transfer (EFT) and HP ALM (Application Life Cycle Management)

PROFESSIONAL EXPERIENCE

Confidential

ETL Architect

Responsibilities:

  • Designed and developed a data model solution for Retail analytics reporting.
  • Provided System and Application Administration for Informatica PowerCenter
  • Developed UNIX shell scripts for flat file pre-processing tasks and transferring the files to ETL server.
  • Created DDL’s for the DB tables, views and used them according to the new business requirement.
  • Performed detail data analysis of both data elements requested by the business and data source and documenting data source definition, source-to-target mapping, and logical structures for the data warehouse/data mart.
  • Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure, SQL transformation, Router, Connected & Unconnected lookups, Union, Expression and Aggregator transformations.
  • Convert Promotion XML data files into Oracle PL/SQL rows and columns used the options such as SQLLOADER, utl file, and XML CLOB which will be used in the KPI reports.
  • Developed Re-Usable Transformations, Functions and Mapplet.
  • Responsible for Unit testing, System testing and Integration testing of mappings and workflows.
  • Involved in Code migration.
  • Created and maintain technical documentation including operations run books, user guides, and standard operating procedures

Environment: MicroStrategy 10.1, Windows XP, UNIX AIX, Informatica 10.1, DB2, GlobalScape Enhanced File Transfer (EFT), Sybase

Confidential

ETL Developer

Responsibilities:

  • Used ETL Informatica tool to develop jobs for extracting, cleaning, transforming, and loading data into RBI data warehouse.
  • Used advanced transformations like Java,XML and HTTP to send the webservice request and process/parse the Json and XML files to DDM Data warehouse.
  • Created databases and schema objects including tables, indexes, views, functions, synonyms and applied constraints, connected various applications to the database. Build dimension table surrogate key management system.
  • Created linked server to connect to the source system which was for building the RBI Audit reports.
  • Used team Foundation server for version control and deployed the code using SQL server project deployment model.
  • Created scripts using WinSCP to compress and transfer the files to FTP server.
  • Created command line shell scripts for automatic triggering of reports from the BI application after completion of the daily/hourly loads.
  • Create Triggers, Functions, stored procedures in SQL server to transform the data from staging layer to RBI warehouse.
  • Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
  • Configured database email and Implemented automatic ticket generation process in Service now for effectively tracking the Failures.
  • Created project documents which includes SOP, Design document and User training document.

Environment: MicroStrategy 10.1, Unix AIX, Microsoft SQL Server 2012, SQL Server Integration Service, SQL Server 2012/2017, MicroStrategy 10.x, Business Intelligence Development Studio,DB2,Oracle

Confidential

MicroStrategy Report Developer /ETL Developer

Responsibilities:

  • Created MicroStrategy Schema objects and Application objects using MicroStrategy Desktop and Architect.
  • Moved Objects from one environment to other.
  • Creation of Interactive Dashboards in reports & utilized the new features to convert the dashboards into Flash mode.
  • Created Complex Metrics, Nested Filters, Nested Prompts, Custom Drill Maps, Templates for Graphs and Templates for Drilled reports
  • Tracking enhancement projects to ensure the project delivery on time.
  • Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure, SQL transformation, Router, Connected & Unconnected lookups, Union, Expression and Aggregator transformations.
  • Extensively worked with both Connected and Unconnected Lookup Transformations.
  • Responsible for Unit testing, System testing and Integration testing of mappings and workflows.

Environment: MicroStrategy 9.4.1, SQL Server 2012, Windows XP, UNIX AIX, Informatica 9.6, DB2, GlobalScape Enhanced File Transfer (EFT), Sybase, Service Now

Hire Now