We provide IT Staff Augmentation Services!

Senior Etl Developer Resume

Lutherville Timonium, MD

PROFESSIONAL SUMMARY:

  • 8 years of experience in the concepts of BIDW (Business Intelligence and Data Warehousing) Data extracting, Data profiling, Data cleansing, Data integration, Data transformation and loading into Data marts and Data warehouse using tools like Informatica, Teradata, and Unix Scripts.
  • Worked on ETL Tool Informatica Power Center 9.x (Designer, Workflow Manager, Workflow Monitor and Repository Manager) on Mapping, Performance Tuning and ETL concepts.
  • Extensive experience in Data Warehousing, Data Modeling, Data Integration, Data Migration, ETL process and Business Intelligence Migration, Enhancement, Testing and Production Support Projects, and SQL Server Integration Services (SSIS).
  • Expert in designing and developing complex Mappings, Mapplets, Transformations, Workflows, Worklets, scheduling the Workflows and sessions using control - M.
  • Extensive experience in using various Informatica Designer Tools like Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer and Warehouse Designer.
  • Knowledge on reporting tool SAP Business Objects and Tableau.
  • Good experience in developing the end-to-end process flow diagrams for the given project requirements, which helps to identify the potential risks in the earlier phase of development.
  • Good experiences in Data mining and Data science concepts with certification from IBM.
  • Experience in integration of various data sources with multiple Relational Databases like Oracle, Teradata and SQL Server and worked file formats like flat files like fixed width and delimited data values.
  • Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
  • Experience in identifying Bottlenecks in ETL Processes and Performance tuning of the production applications using Database Tuning, Partitioning, Index Usage, Aggregate Tables, and Normalization/ Denormalization strategies.
  • Worked with Teradata utilities like Fast Load and Multi Load, TPT and Tpump, DDL Commands and DML Commands (SQL).
  • Experience in database performance tuning.
  • Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex queries using SQL. Also loaded large files using SQL Loader.
  • Strong understanding of Data Modeling (Relational, dimensional, Star and Snowflake Schema), Data analysis, implementations of Data warehousing using Windows and UNIX systems.
  • Highly Motivated to take independent responsibility as well as ability to contribute and be a productive team member. And ability to work on multiple projects simultaneously.
  • Exceptional analytical and problem-solving skills and completing the work on time with effectiveness and thus receiving recognition awards like Confidential Championship Award, Bronze Award and On-the spot Awards.
  • Expertise in Planning, Analysis, Design, Implementation, Development, Maintenance and Support for production environment in different domains like Sales, Supply, and Manufacturing.
  • Experienced with the Software Development Life Cycle (SDLC) like Agile (Scrum), Waterfall and Adhoc.

TECHNICAL SKILLS:

Operating System: Windows XP/7/10, UNIX.

Data Warehousing: Informatica Power Center 9.X, SSIS.

Languages: SQL, T-SQL, PL/SQL, Python (NumPy, Biopython), R, Java, C, C++., LISP, Prolog.

Reporting Tools: SAPBO, Tableau.

Database: Teradata, Oracle 10g, MS SQL Server 2008/2012, MS Access, MongoDB.

Data Sciences: Data cleanup and transformation, clustering, grouping, analysis.

Scheduling Tool: Control-M, SSMS

Web Technologies: PHP, JavaScript, HTML, CSS, XML.

Microsoft Suite: Excel, Word, PowerPoint, Access, Project, OneNote, Publisher.

Tools: Visual Studio, Toad, SQL Developer, SQL Assistant, Nexus, Microsoft SQL Server management Studio, WINSCP, Visual Studio Code.

PROFESSIONAL EXPERIENCE:

Confidential, Lutherville Timonium, MD

Senior ETL Developer

Responsibilities:

  • Designed and Developed ETL mappings using transformation logic for extracting the data from various sources systems.
  • Worked on converting technical specifications into Informatica Mappings.
  • Loaded data from different source systems like Flat files, Excel, Oracle, .txt files.
  • Worked with Reporting team to get to an agreement on what level of complexity to be handled by ETL and reporting side.
  • Worked on Informatica tuning at mapping and sessions level.
  • Extensively used Informatica and created mappings using transformations like Source Qualifier, Aggregator, Expression, Filter, Router, Normalizer, Lookup, Update Strategy, and Sequence Generator.
  • Used Mapplets, Parameters and Variables to facilitate the reusability of code.
  • Worked on Pre and Post SQL queries on target.
  • Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
  • Created scripts which are reviewed by DBA's. Done many comparisons between source data and staging data through excel for the QA.
  • Worked on various UAT and PROD incidents raised by users and which require timely response for L3 support.
  • Solved many production tickets as part of PRODUCTION L3 SUPPORT.
  • Involved in Unit testing, User Acceptance testing, Stress Integration testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
  • Worked on Confidential (technical design document) incorporating the changes done.
  • Responsible for Regression testing ETL jobs before test to production migration.
  • Created scripts based on existing procedures according to the user requirements.
  • Investigated and fixed problems encountered in the production environment on a day to day basis.
  • Troubleshoot the data and performance issues raised by user community, designed, developed and deployed the code to fix them.
  • Used the technologies like Informatica, Teradata, Control-M, Unix putty, Share point.

Confidential, Round Rock, TX

Sr. ETL Developer

Responsibilities:

  • Involved in requirements gathering, identifying KPI and defining them at database level.
  • Defining the ETL process, loading order of tables.
  • De-normalizing existing schemas to prepare DataMart to meet reporting requirements.
  • Created end-to-end process flow for requirements, which helps to identify the potential risks in the earlier phase of development.
  • Developed re-suable mapping and worklets and standardized the ETL process.
  • Worked as a SME in the project.
  • Prepared Confidential (Technical Document Design) based on the BRD (Business Requirement Document).
  • Responsible for regressions test on the data because of huge volume to identify performance issues.
  • Active participation in UAT.
  • Worked on various data sanity checks and cleaning and ensuring data is loaded accurately.
  • Worked extensively on processing data from flat files, SQL server tables into Data warehouse tables using Teradata utilities like fload and mload.
  • Used performance tuning and added indexes in Teradata.
  • Designed incremental, stage, base and package tables based on the design solution.
  • Prepared post deployment support documents for the Production Support team with the information need for to maintain the project in the production environment.
  • Used the technologies like Informatica, Teradata, SQL Server Control-M

Confidential

ETL / BI Developer

Responsibilities:

  • Developing macros, reusable code components using Teradata.
  • Transformed and modernized legacy software systems through the re-engineering of business processes to meet futuristic customer demands. Through this effort, was responsible for full system development life cycle, including the migration of legacy systems data to an integrated database.
  • Data Migration activities include data profiling and data analysis.
  • Implemented various data validation rules like tie outs, sanity checks, and data validations.
  • Worked with Session Logs and Workflow Logs for Error handling and Troubleshooting in all environment.
  • Developing and monitoring ETL jobs and preparing roll back strategies.
  • Used source and target, filter, aggregation, lookup, router, expression and aggregator transformations.
  • Prepared deployment documents from Dev to SIT, SIT to Production. Engaged cross functional teams for migration to SIT and deployment.
  • Worked on various data sanity checks and cleaning.
  • Developed end-end flow using Informatica workflows and Teradata scripts.
  • Developing BOBJ universe and reports with data validation techniques with rollback strategies. Worked as Full Stack developer, Used Agile (Scrum) SDLC.
  • Used the technologies like Informatica, Teradata, Control-M.

Confidential

ETL Developer

Responsibilities:

  • Data modeling and data warehouse designing.
  • Involved in development of data mapping documents along with Data architect.
  • Analyzing Source systems data.
  • Used source and target, filter, rank, aggregation, lookup, router, expression transformations.
  • Designed incremental, staging, base and package tables.
  • Active participation in UAT and system integration testing.
  • Break up the work into task list and estimate based on simple, medium and complex methodology in TFS and assign the task to the ETL developer
  • Created Triggers and Stored Procedures using PL/SQL.
  • Working closely with DBA for identifying performance issues with Teradata scripts.
  • Generated Parameter Files for all the mappings using UNIX scripts.
  • Validated the results using BOBJ reports with ETL tools and the business provided data snapshots.
  • Preparing deployment documents.
  • Scheduled jobs by identifying and monitoring base system data refresh mechanisms.
  • Used the technologies like Informatica, Teradata, Oracle, Control-M, and SAP BOBJ.

Confidential

ETL Developer

Responsibilities:

  • Involved in development and designing of data marts for end user reporting purpose using Informatica mapping and Teradata macros.
  • Used SQL transformation for parameterizing the macro to avoid spooling issues.
  • Designed Informatica mappings, workflows.
  • Used source and target, filter, rank, aggregation, lookup transformations.
  • Assisted the peers to the existing environment design and creating end-to-end process flow.
  • Creating indexes om existing schemas and performance tuning by quick retrieval of data.
  • Prepared deployment documents from Dev to SIT, SIT to Production. Engaged cross functional teams for migration to SIT and deployment.
  • Worked on various data sanity checks and cleaning.
  • Worked extensively on processing data from flat files, Oracle, SQL server tables into Data warehouse tables using Teradata utilities like fload and mload.
  • Used the technologies like Informatica, Teradata, SQL Server. Control-M.

Confidential

ETL Developer/ BI Developer

Responsibilities:

  • Using HWM and LWM concepts for incremental load of data.
  • Used TD Lab environment for all data analysis.
  • Used UNIX scripts for implementing HWM and LWM with Informatica.
  • Worked extensively on processing data from flat files, SQL server tables into Data warehouse tables using Teradata utilities like fload and mload.
  • Root cause analysis for incorrect metrics calculations and providing feasible solution.
  • Recommended approaches to solve with fixes, secured approval on sample data.
  • Used T-SQL in database for data consistency and SSIS for data loads and SSMS for scheduling jobs.
  • Used Tableau for data visualization.

Confidential

Software Developer

Responsibilities:

  • Built a website based on a library data and developed ontologies for individual users
  • Used JSON and Java
  • Modified the display of the website based on user ontologies, to optimize the experience of user.

Confidential

Software Developer

Responsibilities:

  • Building a website for the online hospital.
  • Establishing doctor patient relationship virtual.
  • Used JSP Oracle 10g

Hire Now