We provide IT Staff Augmentation Services!

Sr. Data Analyst/ Etl Developer Resume

Irving, TX

PROFESSIONAL SUMMARY:

  • 12 + years of professional experience in IT, and the past 9 + years spent primarily on Data warehouse projects using Informatica Power Center Server, Hadoop EcoSystem, IDQ, Business Objects, Cognos, Teradata, SQL Server and Oracle on UNIX and Windows platforms.
  • Expertise in full life cycle of ETL (Extraction, Transformation and Loading) using Informatica Power Center (Repository Manager, Mapping Designer, Workflow Manager, Workflow monitor).
  • Experience in Data Load with Informatica CDC (Change Data Capture).
  • Experience in Teradata with Fast Load, Multi Load and BTEQ.
  • Experience in Hadoop Components using Spark, Python, Sqoop, Oozie, Hive etc.
  • Experience in SQL Server Integration Services   (SSIS)  and  SQL Server Reporting Services (SSRS)  with good knowledge on SQL Server Analysis Services   (SSAS) .
  • Experience in DataStage implementations, Development and support.
  • Experience in Oracle Procedures .
  • Experience in file transfer thru SFTP and B2B .
  • Experience in UNIX and Windows programming.
  • Used Tidal and Tivoli for job scheduling tool.
  • Experience in developing Data M odel using Kimball and Agile methodology.
  • Experienced in full Software Development Life Cycle (SDLC) process.
  • Experience in working on Tableau .
  • Solid understanding of Relational (ROLAP) and Multidimensional (MOLAP) modeling, broad understanding of data warehousing concepts, Star , Kimball and Snowflake schema database design methodologies.
  • Good exposure to D evelopment, Testing, Debugging, Implementation, Documentation & P roduction S upport.
  • Good exposure to Excel with Pivots, PivotCharts , Extract data thru Data Connection etc.
  • Good understanding on Hadoop components like Hadoop Map Reduce, HDFS Frame work, HIVE, PIG, HBase, Zookeeper, Sqoop, Oozie, and Flume.
  • Managed and co - ordinate tasks between multiple teams (Offshore and Onsite) for many projects.
  • Ability to work effectively in a supervisory and non supervisory environment as a team member as well as an individual.

TECHNICAL SKILLS:

ETL Tools: Spark 2.0, Informatica(IntegrationService/PowerCenter/PowerMart) 9.6.1/9.5.1/8.6.1/7 , DataStage 8.1/8.0.1

BI Tools: Business Objects 6.5/5.1, Cognos

Databases: Hive 2.0.1, Teradata 9.5.1/9.5, Oracle 11g/10g/9.x,SQL Developer 1.5.5, MS SQL Server 2008, SQL Server 2005

Languages/Others : Python, SQL, PL/SQL, UNIX and Windows

Packages: MS Office (MS Access, MS Excel, MS Visio, MS PowerPoint, MS Word)

OS: Windows 10/95/98/2000/ XP/7/8 Professional/NT, UNIX

Hadoop: HDFS, Hadoop MapReduce, Zookeeper, Hive, Pig, Sqoop, Flume, Oozie, Spark

Data Transfer: Data File thru SFTP and B2B.

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Sr. Data Analyst/ ETL Developer

Responsibilities:

  • Collection and analyzing of Churn Data periodically.
  • Load and Build Adhoc Reports using Teradata Utilities and scheduling jobs thru SSIS Packages .
  • Sqooping Data from HDFS and ETL Jobs using Spark, Python and loading it in Hive .
  • Extensively used Informatica for ETL Development.
  • Reports were produced on Tableau and Excel Pivots with Auto refresh ScoreCard.
  • Prepared the Deployment documents for C ode M igration.
  • Involved in Production Support.
  • Performance Tuning of Jobs.
  • File transfer thru SFTP .
  • Worked closely with DBA’s in performance issues.
  • Ensures continuing operational quality by documenting bug fixes and enhancements assigning tasks to developers, testing and updates.

Environment: Teradata 15.10, Informatica Power Center 9.5.1, Spark 2.0, Python, Hive 2.0.1, Tableau 10.2, UNIX, SQL Server etc.

Confidential, Richardson, TX

Sr. Informatica SQL Developer and Data Analyst 

Responsibilities:
  • Design critical part that will be the perquisite of conversion
  • Implement the changes from mappers / business analyst on daily basis
  • Worked with the Team to validate the data alignment and testing to understand the issues and fix them
  • Created databases tables, triggers, views, stored procedures, functions, Packages, joins and hash indexes and collect Statistics.
  • Led the end to end system testing
  • Responsible for code migration, implementation and monitoring with Operations onshore and offshore teams
  • Post production support and data analysis to fix bugs and performance tuning.
  • Used SQL Developer to write SQL queries for validating constraints, indexes

Environment: Informatica Power Center 9.5.1, Oracle 11g, UNIX, SQL Server 2008, SQL, PL/SQL, DataStage 8.1/8.0.1.

Confidential, Columbia,MD

Sr. Informatica/ ETL Developer

Responsibilities:

  • Export the DataStage to XML file and re-import to Informatica .
  • Closely check and add transformation and logics which are missed during importing.
  • Developed new the mappings using Source Qualifier, Expression, Lookup, Router, Filter, Sequence Generator, Sorter, Update Strategy, Joiner and Union transformation based on the new requirements.
  • Prepared the Deployment documents for code migration and Data migration.
  • Involved in Unit testing of the mappings.
  • Performance Tuning of sessions and mappings.
  • Experience in file transfer thru SFTP .
  • Worked closely with DBA’s in performance issues.
  • Used Tivoli for job schedule.
  • Experience in developing Agile methodology.
  • Worked with Dell Offshore team.

Environment: Informatica Power Center 9.5.1, Oracle 11g,, UNIX, Windows, SQL Server 2008, SQL, PL/SQL, DataStage 8.1/8.0.1.

Confidential, Irving, TX

Sr. Informatica/ ETL Developer

Responsibilities:

  • Analysis of the existing mappings.
  • Enhancements to the existing mappings and sessions.
  • Developed the mappings using Source Qualifier, Expression, Lookup, Router, Filter, Sequence Generator, Sorter, Update Strategy, Joiner and Union transformation based on the requirements.
  • Extensively used Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer.
  • Extensively used FLOAD and MLOAD utilities in Teradata through Informatica.
  • Extensively used Push down Optimization in Informatica.
  • Worked on IDQ.
  • Involved in testing of the mappings and matching the data with existing warehouse.
  • Converted Unix-Oracle scripts to Unix-BTEQ scripts.
  • Prepared the Deployment documents for code migration and Data migration.
  • Involved in Production Support.
  • Involved in Unit testing of the mappings.
  • Performance Tuning of sessions and mappings.
  • Experience in file transfer thru SFTP and B2B .
  • Experience in DataStage implementations, Development and support.
  • Experience in developing Data M odel using Kimball's methodology.
  • Worked closely with DBA’s in performance issues.

Environment: Informatica Power Center 9.5.1/9.1.1 , Oracle 11g, Teradata, UNIX, SQL Server, SQL, PL/SQL, DataStage 8.1/8.0.1.

Confidential, Irving, Texas

Sr. Informatica/DW Developer

Responsibilities:
  • Understanding the existing system.
  • Involved in preparing the Mapping Document.
  • Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Filter, Sequence Generator, Sorter, Stored Procedure, Update Strategy, Joiner and Rank transformations, SQL transformation, Union transformation.
  • Preparing Sessions, Workflows, Worklets for Mappings.
  • Developed reusable Mapplets using Mapplets Designer.
  • Designing of control tables, and data error tables.
  • Developed reusable transformations using Transformation Developer.
  • Interacting with the testing team to solve the issues.

Environment: Informatica Power Center 8.6.1, Flat files, Oracle 10g, SQL,PL/SQL, Putty, Windows XP, Toad, Tivoli, Business Objects, Unix scripting, Win SCP.

Confidential, Richmond, VA

Sr. Informatica/ DW Developer

Responsibilities:
  • Established Informatica platform at client location.
  • Worked with business analysts for requirement gathering, business analysis, and testing and project- coordination.
  • Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules.
  • Developed complex mappings with transformations like lookup, router, aggregator, expression and joiner confirming to the business rules.
  • Performance tuning of mappings, transformations and sessions to optimize session performance.
  • Created session tasks (session, command etc.) and managed database connections and scheduled workflows.
  • Designed high performance mappings by using iterative variable logic in Expression Transformation.
  • Used DT Studio component "parser" to load HL7 formats.
  • Good knowledge about DT Studio components like Mapper, Serilazer and Splitter.
  • Used Unstructured Date Transformation to integrate DT Studio components with Informatica
  • Used SQL*Loader for loading the stage tables.
  • Created SQL scripts for views, synonyms
  • Performed unit and integrated testing.
  • Prepared documentation for business data flow from source to mart.
  • Move the mappings and scripts between various environments like the Development, QA and production.
  • Creating /Modifying Batch scripts.
  • Attend to day today maintains of the loading process.

Environment: Informatica Power Center 7.1/6.2, Flat files, Oracle 9i/8i, Control M, DB2, UNIX (SunOS 5.8), PL/SQL, SQL * Loader, MS SQL Server 2000, SQL Navigator, Windows NT 4.0 Erwin 4.0, Micro Strategy 8.0.2, Mainframes, Toad 8.6, Tera Term Pro, Win SCP

Confidential, Harrisburg, PA

Sr. Informatica Developer

Responsibilities:
  • Understand the existing business system, business exchanges information and Dimensional Data Model of the eCIS.
  • Prepare the conversion document plans, synchronization documents plans and design appropriate mappings for conversion and synchronization.
  • Test synchronization mappings and compare results with SAP outcome results to verify both results are in sync.
  • Schedule mappings using OPCONS scheduler.
  • Error Out invalid data and analyze the root cause for errors.
  • Maintain Envelope tables to identify the data loads.
  • Written DOS scripts to Copy/ Delete the flat files in appropriate folders and initiate scripts from Informatica sessions.
  • Data cleansing, Validations, data transformations and calculations in Data flows/ Work flows.
  • Created complex Data Flows to load the data mart and monitored them.

Environment: Informatica PowerMart /Power Center 7.2, ETL, Business Objects 5.0, Oracle 9i, DB2 (UDB), Autosys, Teradata V2R5/V2R4, UNIX Shell Scripting, ERWIN 3.5.2, Windows NT 4.0

Confidential

ETL Developer

Responsibilities:
  • Involved in System study, Analysis, and Project Planning.
  • Involved in Database Designing and Application programming.
  • Writing Database Packages, Stored Procedures & Triggers.
  • Tuning of SQL-Statements, stored procedures
  • Involved Unit testing and deployment of the application.
  • Training the users, support and maintenance of the application.
  • Discussions with client for bug fixing and customization of application.
  • Analyze data processing requirements to create an ETL packages/Mappings
  • Prepare and develop a document specification for designing the mappings/Packages.
  • Design the mappings to Extract, Transform and load the data from source to the target system.
  • Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.
  • Worked with heterogeneous sources to extract data from different sources.
  • Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
  • Data cleansing, Validations, data transformations and calculations in mappings.
  • Responsible for creating business solutions for Incremental and Full loads.
  • Monitors and executes performance tuning of initial and incremental loads.
  • Responsible for processing Cubes and Dimensions.
  • Cubes/Reports created for HP Global Sales and Marketing using Analysis services.
  • Generating scripts for table definition for both dimension and fact tables.

Environment: Informatica 6.2/5.1.2/4.7 , Oracle 8i, SSIS 2005, Business Objects, UNIX, Windows NT

Confidential

ETL Developer

Responsibilities:
  • Developed Conceptual and logical ETL applications to populate data from source to target database by Informatica tool.
  • Implemented slowly changing dimensions Type2.
  • Create Mapplets for Reuse Transformation logic in Mappings.
  • Responsible for generating Reports from Central Confidential Server, using Business Objects Tool.
  • Create Mappings in Mapping Designer for transforming Source Data into Target Database by Informatica Tool.
  • Create Reusable Transformations in Transformations Developer.
  • Responsible for generating Reports from Central Confidential Server, using Business Objects Tool.
  • Design and develop application to solve business functional requirements.
  • Creating oracle objects like Object Types, Object Views, Packages, Stored Procedures, Functions and Sequences in Oracle8.1.
  • Generating Reports against the application data model using Business Objects Tool.
  • Performed testing the application.

Environment: Informatica Power Center 7.1.1, Flat files, Oracle 8i, UNIX, SQL, PL/SQL, TOAD

Confidential

Oracle Developer

Responsibilities:
  • Understanding the requirements for Recruitment, Training and Appraisal modules.
  • Involved in System study, Analysis, and Project Planning.
  • Writing Database Packages, Stored Procedures & Triggers.
  • Designing forms to navigate from main screen to different module screens.
  • Responsible for creating stored procedures, triggers, functions etc in the backend.
  • Participate in Unit testing.

Environment: Windows, UNIX, SQL, PL/SQL, Oracle 7.1.1

Hire Now