We provide IT Staff Augmentation Services!

Etl Developer Resume

5.00/5 (Submit Your Rating)

SUMMARY:

  • 8+ years of experience in BI reporting, analysis, design, development, coding and testing with emphasis in technical, business and client management aspects of IT solutions.
  • Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
  • Experience in integration of various data sources like flat files, DB2 and Oracle using Informatica
  • Proven skills in data modeling engineering with emphasis in high - volume, high-availability enterprise applications and data.
  • Strong knowledge in developing database queries
  • Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Teradata, Oracle and SQL Server Databases.
  • Proficient in the Integration of various data sources with multiple relational databases like Oracle, MS SQL Server, MY SQL, and Teradata.
  • Streamlined the Teradata scripts and shell scripts migration process on the UNIX box.
  • Experience in working Unix scripts and complex SQL queries
  • Experience in multiple platforms using Windows SERVER/LINUX/UNIX Platform.
  • Expert in troubleshooting/Debugging and improving performance of Informatica mappings.
  • Worked as an ETL developer in Data Warehouse Project. Analyzing data related to Shipment, Manifest, Customer, Sales, Operations & Delivery and Claims. Working closely with Data Warehouse Architect, Data Modelers, Data Analysts and BI Developers to understand the Requirements. Worked on migrating the Cognos reports to SSRS.
  • Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
  • Enthusiastic and goal-oriented team player processing good communication and interpersonal skills.

TECHNICAL SKILLS:

DB and Programming Environment: SQL Server, Oracle, Access, MySQL, Teradata, Postgres.

Tools: and Technologies: Crystal Reports, SSIS, SSRS, SQL Loader, SQL Plus, TOAD, SQL Navigator, Query Analyser, R.

Platforms/OS: Windows /LINUX/UNIX.

Software Engineering: Quality assurance, Implementation, Unified Modeling Language (UML), SCRUM, AGILE, Software Metrics, Entity Relationship Modeling (ERD).

PROFESSIONAL EXPERIENCE:

Confidential

ETL Developer

Responsibilities:

  • Provided reporting and analysis (Data Science) for the national engineering and technical operations division both in SSRS (2005/2008/2014 ), OBIEE 11g and Tableau.
  • Provided numerous change management, outage management and problem management reports based on Ticketing system (TTS Remedy).
  • Provided CPE performance reporting on HSD, VOICE and VIDEO (RESI /COMM) for various market and regions
  • Provided complex reports on daily, weekly, monthly, quarterly basis to CNOC, PNOC, BNOC and network core & applications.
  • Provide detailed tracking and analysis of cable modems, CMTS and other inline hardware.
  • Designed a website and reporting tool to allow engineers to track device firmware updates for 14 days pre/post of test deployment dates. Expanded its use to CDV devices as well.
  • Designed an Analytics portal web site to give management an at a glance view of all our key metrics. It is customizable to each user of the site giving unique views of the data.
  • Created a custom server monitor to track all our server metrics across our various servers. This also monitors all our ETL processes and provides graphical as well as email notifications to the team.
  • Created network Hygiene portal for data cleanup activity for Core Network and network applications.
  • Responsible for all the data imports and transformations from different source system like Amazon cloud, Hive, Hadoop, MySQL, MS SQL, ORACLE and etc.
  • Responsible for all the IVR data and User call volume data loads to Haystack (Guavas).
  • Provide server support for our team, recommend new and/or upgrades to existing hardware.
  • Worked on the NDW and Meld platform for the subscriber reporting.
  • Training in Hadoop, Pig, and Hive.

Environment: SQL Server, SSIS, SSRS, Tableau, OBIEE, TERADATA, MYSQL, NETEZZA, ORACLE 10g, Scripting

Confidential

Informatica Developer

Responsibilities:

  • Communicated with business team and gathered requirements.
  • Incorporated identified factors into Informatica mappings to build Data Mart.
  • Incorporated data masking transformation in all the mappings to apply masking technique.
  • Used Key/Expression Masking technique for the corresponding attributes.
  • Used Alphabet masking for first name, last name and Alpha numeric masking for address fields and Digit masking for phone numbers etc.
  • Developed Informatica Mappings/Workflows to refresh data from SQL Server Database into Teradata.
  • Good hands on experience with Fast load, multi load and Tpump utilities etc.
  • Data extraction and data Transfer Teradata Database using utilities / tools like fast load and multi load.
  • Designed Informatica complex Mappings and Workflows to be re-start able after a failure.
  • Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Mart.
  • Implemented various Performance Tuning techniques on Sources, Targets, Mappings, Sessions, Workflows and database.
  • Created a parameter file for each application and incorporated database connection info inside it.
  • Created workflows/work let for each application and Refreshed the list of tables.
  • Prepared Technical Documents related to design, development and testing as per Data Masking Project.
  • Captured source/target data into an excel file and compared target data with source data to verify masking rule.
  • Worked extensively on Data Migration.
  • Good Hands on experience with Oracle Database.
  • Hands on experience with Informatica Identity Resolution.
  • Worked on Handling Anomalous Data Entry as part of IIR etc.
  • Worked on Identity Resolution and the Market as part of IIR.
  • Worked on Informatica MDM etc...
  • Worked on Informatica New Version 9.6 and Informatica 9.1 etc.
  • Good Hands on experience with expectation logic, Error Handling and Change management process.
  • Worked extensively on AWS.
  • Good Hands on experience with AWS cloud.

Environment: Informatica Power Center 9.6, CDC, SQL Server 2005, Oracle11g, Teradata, SQL, PL/SQL, Win SQL, UNIX Shell Scripts.

Confidential

ETL Informatica Developer

Responsibilities:

  • Actively involved in interacting with business users to record user requirements and Business Analysis.
  • Designed and Developed mappings using different transformations like Source Qualifier, Expression, Lookup (Connected & Unconnected), Aggregator, Router, Rank, Filter and Sequence Generator.
  • Used Designer to create mappings using different transformations to move data from source to target Data Warehouse.
  • Translated requirements into business rules & made recommendations for innovative IT solutions.
  • Outlined the complete process flow and documented the data conversion, integration and load mechanisms to verify specifications for this data migration project.
  • Parsing high-level design spec to simple ETL coding and mapping standards.
  • Worked with Power Center Designer tools in developing mappings and Mapplets to extract and load the data from flat files and Oracle database.
  • Maintained warehouse metadata, naming standards and warehouse standards for future application development.
  • Created the design and technical specifications for the ETL process of the project.
  • Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
  • Created Update Strategy and Stored Procedure transformations to populate targets based on business requirements.
  • Error review, log and restudy/recode of the system.
  • Debugging and Trouble Shooting Of Informatica Mappings.
  • Design and develop data loading programs to support real time data loading to Data Marts
  • Used Parameter files to manage the relational connection in different environments.
  • Tuned SQL Queries in Source qualifier Transformation for better performance.
  • Used Informatica Power Center Workflow manager to create sessions and workflows to run the logic embedded in the mappings.
  • Developed Task/Sessions and Work flows as required with session variables.
  • Developed various packages, stored procedures, and functions for business needs.
  • Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.
  • Used Update strategy and Target load plans to load data into Type-2 /Type1 Dimensions.
  • Created reusable transformations and Mapplets and used them in various mappings.
  • Responsible to move mapping elements to UAT, QA&PROD by Import/export as XML files subsequently create the migration documents for UAT, QA&PROD.

Environment: Informatica Power Center 9.6.1 (Repository Manager, Designer, Workflow Manager, Workflow Monitor and Repository Server Admin console), TOAD, Oracle 12c/11g, Control-M, Shell Scripting, XML, LINUX

Confidential

Informatica Developer

Responsibilities:

  • Developed standard and re-usable mappings and Mapplets with various transformations like expression, aggregator, joiner, source qualifier, filter, lookup, stored procedure and router.
  • Involved in scheduling jobs in scheduling tools.
  • Effectively used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from flat files to Oracle database
  • Used appropriate corrective actions for source qualifier queries in Informatica mappings for faster retrieval of data
  • Constructed workflows having Command, Email Session, Decision and wide variety of tasks
  • Maintained development, test and production mapping migration using Repository Manager
  • Greatly involved in enhancements and maintenance activities
  • Demonstrated excellent ability for unit testing and data testing in both development and test environment
  • Handling Change Requests.
  • Handling Ad-hoc requests.
  • Involved in automated and manual FTP.
  • Code walkthrough to ensure the programs are in accordance to ASA standards
  • Enhancement, Testing and Documentation of projects.
  • Handling failed jobs in production environment within SLA.

Environment: DB2, Oracle 10g, SQL, Informatica 8.6, Quality Center.

Confidential

SQL Developer

Responsibilities:

  • Designed SSIS Packages to extract data from various OLTP sources, Text Files, XML (Extensible Markup Language) Files, MS SQL Server 2008/2012, Excel and MS Access 2007 to EDW system (SQL Server 2012).
  • Wrote T-SQL queries with the help of Stored Procedures, Functions, Triggers, Cursors, Views, and Indexes.
  • Planned, Defined and Designed data based on business requirement and provided documentation.
  • Gathered data and documenting it for further reference.
  • Designed Database using Erwin data modeler.
  • Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Cache Transform, Conditional Split and Derived column etc. in SSIS
  • Developed SSIS Packages using Look Up Values & implementing rules provided by Business in the mapping document.
  • Developed SSIS packages using Fuzzy Look Up and Fuzzy Grouping for data cleansing purpose.
  • Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.
  • Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
  • Modified the existing SSIS packages to meet the changes specified by the users.

We'd love your feedback!