We provide IT Staff Augmentation Services!

Sr. Informatica Etl Developer Resume

SUMMARY

  • IT professional with 8 years’ experience in Data Analysis, Design, Development, Implementation and Testing of Database/Data warehousing/Data Integration applications.
  • Highly Proficient working in Agile methodology and worked in the ecommerce, Insurance, Banking and Retail industries in various roles: Sr. Informatica ETL Developer, Informatica ETL Developer, Data Analyst, informatica Production Support Analyst, ETL Quality Assurance Lead and ETL QA Analyst.
  • Knowledge on Autosys and Control - M scheduling tools to run the jobs.
  • Well versed in system analysis, ER/Dimensional Modelling, Database design and implementing RDBMS specific features.
  • Expertise in data ingestion and transformation technique using ETL tools like Informatica PowerCenter, Ab Initio and ERwin.
  • Skilled in visualizing, manipulating, analysing large datasets to further create effective reports and dashboards with Tableau desktop.
  • Hands on experience with Data Loading, Data Cleaning, Data Wrangling and making conclusions from the data for decision-making purposes.
  • Proficient in Data analysis, Data modeling, Database design and Data migration.
  • Created stored procedures, functions in Oracle, Teradata to perform the transformations.
  • Good knowledge on PL/SQL, Triggers, Functions, Analytical functions.
  • Experience building data pipelines in any public cloud (AWS, GCP Dataflow, Glue, Azure DataFactory) or any equivalent
  • Experience in data modeling, data design and persistence (e.g. warehousing, data marts, data lakes).
  • Strong Knowledge of Big Data architectures and distributed data processing frameworks: Hadoop, Spark, Kafka, Hive
  • Self-motivated achiever who is committed to success and adept at juggling multiple tasks in high-pressure environments.

TECHNICAL SKILLS

Languages: Perl, Python, C, C++, Java, .NET, JavaScript, HTML, CSS, XML, SQL, PL/SQL, No SQL, UNIX Scripting, Shell Scripting

Databases: Oracle 12c, 11g, 10g and 9i, Teradata, DB2, SQL Server 2005/2008 Integration (SSIS) and reporting services (SSRS), MySQL, PostGres DB, MangoDB

ETL Tools: Informatica Power Center 10.x, 9.x, 8.x and 7.x, Data Stage 11.5,11.3,9.1/8.7, Ab Initio Co.Op 2.15, GDE 1.15.9.2, Pentaho

BI Tools: SAP BusinessObjects, Tableau, QlikView, Power BI

SaaS/PaaS: ServiceNow, AWS, Azure

Operating Systems: Windows, Mainframe, LINUX and UNIX

Application Tools: HP Service Manager, HP Quality Center, Toad, SQL Developer, Erwin, Control M, Putty, File Zilla, WinSCP

Other skills: Agile, Waterfall, ITIL, Ruby on Rails, Snowflake

PROFESSIONAL EXPERIENCE

Sr. Informatica ETL Developer

Confidential

Responsibilities:

  • Interacted with the business users to gather the requirements and involved in data analysis.
  • Designed the mappings between sources (external files and databases) to Operational staging targets.
  • Extensively dealt with change capture techniques for implementing slowly changing dimensions’ process.
  • Extensively used various Performance Tuning Techniques to improve the session performance.
  • Worked on setting up different environments for development, system testing, UAT testing and Production
  • Worked with Data Modelers, Technical Architects, Customer/end user, Business analysts, and Data analysts to design Technical Specification documents / Mapping documents.
  • Extensively Tested all the developed jobs based on the requirements of the project and deployed the code into production environment.
  • Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
  • Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
  • Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Wrote complex SQL Stored procedures to improve the performance of financial SSRS reports and handled index fragmentation on some tables that are used as sources for the reports
  • Implemented Slowly Changing Dimension Type 1 and Type2 in ETL jobs for certain Dimensions.
  • Wrote Shell scripts in UNIX and PL/SQL scripts to automate daily routine jobs for production databases.
  • Used WINSCP as Open Source tool for accessing Unix Files
  • Strong Knowledge of Big Data architectures and distributed data processing frameworks: Hadoop, Spark, Kafka, Hive
  • The team supported BI reporting for data analytics, statistical analytics, predictive modeling, and dashboards and scorecards to executives on trends and forecasts.
  • Created user accounts in Pentaho Enterprise Console for end users/Business Analysts who were supposed to view the reports using Pentaho User Console.
  • Used Pentaho Data Integration to create all ETL transformations and jobs.
  • Used different types of input and output steps for various data sources including Tables, Access, Text File, Excel and CSV files

Informatica ETL Developer

Confidential

Responsibilities:

  • Created source to target mapping documentations; created mappings, sessions, and workflows in Informatica.
  • Migrated mappings, sessions, and workflows from development to test and production servers.
  • Optimized session performance of existing data marts by altering memory and DTM buffer settings and fine-tuned mappings for optimum performance.
  • Monitored test plan matrix regularly to ensure completion / accuracy of testing and bug fixes.
  • Assisted finance and business users in creation of BI analytical and operational reports. Created staging tables, indexes, and Oracle table views to improve performance of BI reports.
  • Optimized SQL query performance using Explain plans and created index hints.
  • Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database.
  • Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
  • Created procedures to truncate data in the target before the session run.
  • Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
  • Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
  • Analyzed data mart growth for resource planning / utilization to accommodate future data marts.
  • Created and configured workflows, worklets, and sessions using Workflow Manager.
  • Used mapping variables to reference / record values in mappings and passed parameter files in sessions to reassign variable values. Designed mappings to read trailer records from flat files and fail session in case of mismatch in data record count.
  • Implemented business logic using PL/SQL stored procedures, functions, and cursors.
  • Parameterized the hard-coded values and the mappings to increase the re-usability.
  • Wrote complex SQL Stored procedures to improve the performance of financial SSRS reports and handled index fragmentation on some tables that are used as sources for the reports
  • Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
  • Implement performance tuning on a variety of Informatica maps to improve their throughput.
  • Implemented user based security in SSRS reports to limit the access of reports.
  • Work with peers from various functional areas to define IT wide processes like code reviews, unit test documentation and knowledge sharing sessions.
  • Collaborate and work with business analysts and data analysts to support their data warehousing and data analysis needs.
  • Created and used Perl scripts for running workflows and generated log files for the ETL process.
  • Maintain system performance at 95% of queries running under five minutes. Involved in performance tuning of Informatica mapping and UNIX scripts, maintaining current table statistics, optimizing queries, and other duties.
  • Organized scrum meetings for tight project deadlines and prioritized the development teams’ workload
  • Coordinated with Mainframe developers for sending and receiving of the data feed.
  • Created documents for ETL interface specifications, technical design, and unit test plan.
  • Worked closely with business, SMEs, data architects, and mainframe developers to assess business needs and implement solutions within the data warehouse.

Informatica ETL Developer

Confidential

Responsibilities:

  • Developed ETL mappings, transformations using Informatica Power Center.
  • Developed mappings using various transformations like update strategy, lookup, stored procedure, Router, Filter, sequence generator, joiner, aggregate transformation and expression.
  • Involved into source code review, the mappings created by my team members.
  • Prepared deployment document and assisted to deployment team while migration.
  • Involved in creating test scripts.
  • Involved in performance tuning by optimizing the sources, targets, mappings and sessions.
  • Mappings were designed to cater the slowly changing dimensions.
  • Developed several reusable transformations and mapplets that were used in other mappings.
  • Tested the Informatica mappings with manual testing and assisted QA team.
  • Created Stored Procedures, Functions, Views, Cursors, Packages, Exceptions, Joins and Sub Queries.
  • Involved in Oracle database Maintenance and developing queries.
  • Created and maintained the Shell Scripts and Parameter files in UNIX for the proper execution of Informatica workflows in different environments.
  • Implemented External Tables to access data that is stored outside the database in flat files.
  • Developed and implemented Automations to fix recurring Data Fixes till the code fix has been deployed to PROD.
  • Used SQL*Loader to load the data from the flat files to tables.
  • Worked on performance tuning of the SQL queries to improve data conversion process.
  • Involved to prepare deployment documents and supported deployment team to deploy the tasks in QA/ UAT/ PROD.
  • Documented logical, physical, relational and dimensional data models. Designed the Data Marts in dimensional data modelling using star and snowflake schemas.

Informatica Production Support Analyst

Confidential

Responsibilities:

  • Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power Center
  • Designed and customized data models for Data warehouse supporting data from multiple sources on real time. Involved in building Source to Target mapping to load data into DWH
  • Escalate issues and remediation steps effectively and in a timely manner.
  • Perform troubleshooting analysis and resolution of critical applications and batch processes.
  • Monitoring / Closing the service incidents, service requests and problem records assigned to Pop Sync team in HP Service Manager
  • Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions..
  • Built ad-hoc reports using SQL Server Reporting Services (SSRS).
  • Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
  • Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.

Hire Now