We provide IT Staff Augmentation Services!

Sr. Etl Developer& Data Modeler Resume

SUMMARY

  • 13+ years of IT experience in Data Warehouse and Business Intelligence, Design and Implementation of ETL Processes on large scale and small scale projects.
  • Experience in working on different domains such Insurance, Banking & Finance, Retail, and Healthcare.
  • Experience in complete SDLC involving on Business Requirements Analysis, Application Design, Development, testing, implementation and maintenance of Enterprise Data Warehouse applications and providing active and on call production support.
  • Extensive experience in working with ETL tool like Informatica Power Center suites Designer, Workflow Manager, Workflow Monitor, Repository Manager, and Administrator Console. Also, worked in different ETL tool like Informatica Power Exchange, Informatica Developer, Informatica MDMand IBM Data Stage, Data Migrator.
  • Expertise in Conceptual, Logical and Physical Design. Strong knowledge of ODS, DW Design, ER Modeling, Dimensional Modeling, Star and Snowflake schema along with Data Flow Diagrams and Process Models with modeling tools like ERWIN, SQL Developer & VISIO.
  • Experience as a PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle & DB2 Database.
  • Experience in developing and executing Data Integration and Data Migration projects.
  • Effectively made use of Table Functions, Indexes, Table Partitioning, Analytical functions, Query Re - Write.
  • Developed Complex database objects like SQL Queries, Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
  • Experience in Performance tuning with both Database queries and Informatica processes.
  • Experience in integration of various data sources like Oracle, Sybase, DB2, SQL Server, Teradata, COBOL VSAM, Flat Files (.txt, .csv, Fixed/Delimited), Excel and XML files.
  • Expertise in tuning and optimizing the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
  • Proficient in delivering the high data quality by designing, developing and automation of audit process and implementing the reconcile process accordingly.
  • Proficient in ETL Unix shell script processes, data loading, manipulation using UNIX shell scripting, SQL.
  • Experience with scheduling ETL processes with Tivoli Workload Scheduler, Control M, Autosys and Informatica scheduler.
  • Experience with Hadoop Development using components HDFS, Pig, Hive, HBase, Sqoop, Oozie, Scala, Cloudera.
  • Analyzes Business to Technology transition effectively and provide comprehensive design and implementation solutions with the combined technical and functional skills.
  • Strong written and oral communication skills.
  • Excellent team player and self-starter with good ability to work independently and possess good analytical, problem solving and logical skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6/9.5/9.1/8. x/7.x, Informatica Power Exchange, Informatica Developer, IBM Data Stage, Data Migrator, SSIS

Operating Systems: UNIX, LINUX, Mainframes, Windows 95/NT/XP, Solaris.

Databases: Oracle 11g/10g/9i/8i, SQL Server 2012/2008, Sybase, DB2 UDB,Teradata. PostgreSQL

Programming Skills: PL/SQL, UNIX Shell scripts

Database Tools: Toad, IBM Data Studio, Sybase Central, AQUA DATA, SQL Developer

Data Modeling: ERwin Data Modeler, Oracle SQL Developer Data Modeler

Schedulers/Scripting: Tivoli Workload Scheduler, Control M, Autosys and Informatica scheduler

Test Management tools: Quality Center

PROFESSIONAL EXPERIENCE

Confidential

Sr. ETL Developer& Data Modeler

Responsibilities:

  • Work Closely with On-Site BSA, understand the Enterprise reporting requirement and the Existing EDW architecture, Data Model and ETL Process.
  • Worked closely with Business Analysts and was Involved in design and implementation of the ETL processes (Informatica mappings and SQL) to load data into ODS and MDM tables;
  • Involved in Data Modelling & Design. Created the Conceptual, Logical and Physical Data Model.
  • Involved in Data Integration from the Source based on the Business rules.
  • Worked in Data migration on Vehicle Master from the Confidential to Genesis Brand.
  • Worked on creating the various rules and Jobs in Oracle EDQ. Oracle EDQ also used for performing the Data profiling and reports.
  • Performed Informatica administration tasks including creating work folders, assigning owners using Repository manager, migrating xml code from lower environments to higher environments, scheduling workflows.
  • Involved in analyzing Informatica metadata by querying repository database tables and Performance tuning of Informatica mapping and workflows.
  • Performed Unit Testing, supported the UAT by the business users, and provided production support for the warranty period.
  • Effectively Coordinate and discuss with the Users, Business Intelligence Leader, and the Process leads to clarify their requirements and gather additional information regarding the request to be developed
  • Creating weekly status and monthly status reports and metrics.
  • Actively involved in providing production support and debugging/ resolving ETL issues.

Environment: Informatica Power Center 9.6.1, Oracle SQL Developer Data Modeler, Oracle Enterprise data Quality (EDQ), Oracle 11g, Teradata, SQL/PLSQL,UNIX, Microsoft Visio, MS SharePoint and MS Office applications .

Confidential

Sr. Developer&Data Modeler

Responsibilities:

  • Worked closely with Business Analysts and was Involved in design and implementation of the ETL processes (Informatica mappings and SQL, PL/SQL) to load data into Data warehouse; Used UNIX/Shell commands for flat file processing.
  • Involved in integration of data from various Source System into common fact tables as part of Data Centralization efforts.
  • Involved in Data Modelling & Design. Created the Conceptual, Logical and Physical Data Model.
  • Involved in Data Conversion from the Source based on the Business rules.
  • Performed Informatica administration tasks including creating work folders, assigning owners using Repository manager, migrating xml code from lower environments to higher environments, scheduling workflows.
  • Involved in analyzing Informatica metadata by querying repository database tables and Performance tuning of Informatica mapping and workflows.
  • Implemented Exception/ Error handling processes by creating email tasks and maintaining error tables.
  • Performed Unit testing and supported the UAT by the business users and provided production support for the warranty period.
  • Effectively Coordinate and discuss with the Users, Business Intelligence Leader, and the Process leads to clarify their requirements and gather additional information regarding the request to be developed
  • Creating weekly status and monthly status reports and metrics.
  • Actively involved in providing production support and debugging/ resolving ETL issues.

Environment: Informatica Power Center 9.6, Oracle SQL Developer Data Modeler, SSIS, Oracle 11g, DB2, SQL/PLSQL, SQL Server 2012, Teradata, SQL Developer, UNIX, Microsoft Visio, MS SharePoint and MS Office applications

Confidential

Lead ETL Developer

Responsibilities:

  • Involved in research and POC and then design and development of the Geo Codes for the Mobile App using Informatica Developer tool.
  • Identified the different types of records and data defects in file and based on that the data clean-up and Data Conversion was done using the Informatica Coding.
  • Involved in the Creation of Geo Codes (Latitude and Longitude) of address for each records in file using Informatica Developer.
  • Involved in the Migration and then System Integration testing.
  • Used Power Exchange to import the Mainframe files.
  • Worked on Informatica B2B Data Transformation (DT).
  • Creation of B2B DX partners, profiles, workflows, endpoints for onboarding clients.
  • Worked on Split process, Merge process of multi- client files using Informatica B2B Data transformation and Informatica B2B Data Exchange.(DX)
  • Involved in Migration, Creating error handling processes, UAT & SIT testing, debugging issues and providing support.
  • Involved in analyzing the existing ETL Codes in Informatica and created the low level documents for the Migration Project to help the development in SSIS.
  • Help the reporting team to create the report in SSRS.

Environment: Informatica Power Center 9.6x, Informatica Developer 9.6.1, Informatica Power Exchange,Informatica B2B Data Transformation 9.6.1, Informatica B2B Data Exchange,SQL Server 2008, SSIS,SSRS, Oracle SQL developer, Toad, SQL/PLSQL, UNIX, Mainframe, MS Office.

Confidential

Sr. ETL/ Lead Developer

Responsibilities:

  • Analysis of specifications provided by Clients in the Functional Document and Functional element data dictionaries.
  • Understand the existing flow of data and design the new approach.
  • Performed Gap analysis, created technical design/STT documentation and developedthe new code using Informatica Power Center. Created Informatica mappings to load data from files into the RCDS and ODS tables.
  • Worked on SQL*Loader to load data from flat files to the Oracle Tables.
  • Created scripts to create new tables, views, queries for new enhancement in the application.
  • Created indexes on the tables for faster retrieval of the data to enhance database performance.
  • Created the Unix Shell scripts for file transfer. Email & Archive script for files.
  • Schedule to Jobs in Tivoli Workload Scheduler. Also, created the PMCMD command to run them.
  • Mentored team members and was involved in peer review processes.
  • Worked actively in production support as L2 support. Performed error handling, Change request, ticket handling using the ITSM tool.

Environment: Informatica Power Center 9.1.1/8.1,Sybase, SQL/PLSQL,TWS, UNIX, ITSM, Microsoft Share Point, Visio, MS Office.

Hire Now