We provide IT Staff Augmentation Services!

Sr. Informatica Etl Developer Resume

2.00/5 (Submit Your Rating)

Dayton, OH

SUMMARY

  • Overall 8+ years of experience in all phases of Analysis, Design, Development, Testing and Support on Data warehousing tool Informatica and Snowflake
  • Extensively worked on Informatica Tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet designer, Transformation developer.
  • Extensive experience on developing complex Mappings, Mapplets, Transformations, Workflows, Worklets, Configuring the Informatica Server and scheduling the Workflows and sessions.
  • Worked on performance tuning in Informatica mapping level, session level and database level.
  • Ability to troubleshoot and having excellent client facing skills.
  • I have good knowledge in requirement gathering and Analysis, Application Maintenance, Functional Studies, Quality Reviews and problem-solving skills.
  • Hands-on experience in Business Requirements Gathering, creating High level & Low-level design documentation.
  • Strong knowledge in Business Intelligence, Data warehousing, Dimensional modeling, Star Schema, Snowflake Schema and OLAP concepts.
  • Extensive experience and knowledge of the Project Life Cycle, and Test Plans Development and Execution.
  • Knowledge on loading large sized local files into AWS S3 bucket using AWS CLI Multipart loading, which further loaded into Snowflake via external stages using COPY command.
  • Experience on Snow pipe implementation for continuous data ingestion from S3 bucket.
  • Handled incremental data using Snowflake streams & tasks.
  • In-Depth understanding of snowflake Multi-cluster and credit Usage.
  • In-Depth understanding & experience on snowflake Failsafe & Time travel.
  • In-Depth understanding & experience on clustering to improve compute performance.
  • Worked with heterogeneous data sources like RedShift, Teradata, Oracle, SQL Server and Flat Files.
  • Having solid experience in writing SQL queries and Unix commands.
  • Experience on creating unit test plan and unit test cases based on technical specifications.
  • Extensive experience and knowledge of the Project Life Cycle, and Test Plans Development and Execution.
  • Worked with Toad, SQL * plus, SQL Loader and Teradata SQL assistance.
  • Excellent skills in managing teams as project lead and onsite coordinator.
  • Ability to learn and adapt new technologies quickly.
  • Flexible and versatile to adapt to any new environment or Technology and work on any project.
  • A team player with good communication and Interpersonal skills.

TECHNICAL SKILLS

ETL Tools: Informatica 9.1/9.6/10.2 and Snowflake

BI Tools: Tableau.

Databases: Oracle 9i/10G/11G, Teradata, AWS Redshift

Languages: SQL, PL/SQL (Intermediate level)

Operating Systems: Windows NT/2000/XP/7/10 and UNIX.

Supporting Tools: Putty, Win SCP, JIRA, Remedy and ServiceNow

Others: TOAD, SQL * plus, SQL Developer, SQL Workbench and AWS S3

PROFESSIONAL EXPERIENCE

Confidential

Sr. Informatica ETL Developer

Responsibilities:

  • Gathering requirements from the business users.
  • Involved in creating Impact Analysis, Technical Design Document and Test cases.
  • Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g, Redshift, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
  • Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules.
  • Used various transformations like Source Qualifier, Joiner, Lookup, SQL, and router, Filter, Expression and Update Strategy.
  • Developed mapping parameters and variables to support SQL override.
  • Created mapplets to use them in different mappings.
  • Tuned the Informatica mappings for optimal load performance.
  • Involved in creating and maintaining Indexes and Partition Tables.
  • Used Collections, Records and Ref cursors to process bulk loads to improve performance.
  • Designed SSIS packages Using Control Flow Tasks like for Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, Execute Package Task, Script Task, Send Mail Task and Data Flow Task.
  • Involved in Peer reviews and guided the team for better solutions.
  • Performed Unit, Integration Testing and UAT Testing.
  • Developed UNIX shell scripts to customize the server scheduling jobs and used Autosys to schedule the jobs.
  • Worked as a part of a team and provided 24 x 7 support when required.

Environment: Informatica 9.6/10.1, Snowflake, Redshift, Oracle 11g/10g, S3, Toad,, UNIX, Active Batch, JIRA and ServiceNow.

Confidential, Dayton, OH

Sr. ETL Informatica Developer

Responsibilities:

  • Gathering requirements from the business users.
  • Analyzing the applications.
  • Creating the technical specifications.
  • Developed PL/SQL Packages, Procedures, Functions, Triggers, Views, Indexes, Sequences and Synonyms.
  • Developed ETL processes to load data from different source systems such as Oracle, XML, SQL Server 2008, and Flat Files into target systems i.e. Oracle
  • Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier.
  • Worked with various look up cache like Dynamic Cache, Static Cache, Persistent Cache, Re Cache from database and Shared Cache.
  • Used Informatica’s features to implement Type 2, 3 changes in slowly changing dimension tables.
  • Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations.
  • Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
  • Implemented complex business rules in Informatica Power Center by creating Re-usable transformations, and Robust Mapplets.
  • Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
  • Performed Unit, Integration Testing and validated results with end users.
  • Worked as a part of a team and provided 24 x 7 support when required.

Environment: Informatica 9.6, Redshift, Oracle 11g/10g, S3, SQL Developer, UNIX, Active Batch, JIRA and Remedy.

Confidential, New York, NY

Sr. Consultant

Responsibilities:

  • Involved in complete software development life cycle.
  • Gathered the business requirements by interacting with users.
  • Creating High Level Design Documents.
  • Creating Technical Specifications and Test cases in Quality Center.
  • Involved in performance tuning of queries using Indexing, Partitioning.
  • Used Bulk Binding, Collections, Records, Ref Cursors and Temporary tables to handle bulk loads.
  • Created Materialized views for the reports.
  • Developed mappings in Informatica to load the data including facts and dimensions from various sources into the Data Warehouse, using different transformations like Source Qualifier, JAVA, Expression, Lookup, Aggregate, Update Strategy and Joiner.
  • Developed reusable Mapplets and Transformations.
  • Optimized the performance of the mappings by various tests on sources, targets and transformations
  • Design, develop and Informatica mappings and workflows; Identify and Remove Bottlenecks in order to improve the performance of mappings and workflows
  • Review existing code, lead efforts to tweak and tune the performance of existing Informatica processes
  • Scheduling the sessions to extract, transform and load data into warehouse database on Business requirements.
  • Scheduled the tasks using Autosys.
  • Loaded the flat files data using Informatica to the staging area.
  • Developed Complex mappings in Informatica to load the data from various sources using different transformations.
  • Responsible for providing support and plans to offshore team.
  • Involved in Unit Testing and Integration Testing.
  • Involved in code reviews.
  • Coordinated with different teams while doing production support and analysis.
  • Worked as a part of a team and provided 24 X 7and on-call supports whenever required.

Environment: Oracle 10g, Informatica Power center 8.6, Oracle SQL developer, Toad, UNIX shell scripts, Autosys, Microsoft Visio.

Confidential, CA

ETL Developer

Responsibilities:

  • Involved in gathering the requirements from the business.
  • Worked on Power Center client tools like Source Analyzer, Mapping Designer, Mapplet Designer and Transformations Developer.
  • Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Connected & unconnected lookups, Filter, Router, Sequence Generator, Sorter, Joiner, and Update Strategy.
  • Used Workflow manager for Workflow and Session Management, database connection management and Scheduling of jobs to be run in the batch process.
  • Imported data from various Sources transformed and loaded into Staging Area.
  • Functional and Technical understanding of the Issues.
  • Developed mappings slowly changing dimensions as per requirement.
  • Used shortcuts to reuse objects without creating multiple objects in the repository.
  • Involved in Creating Sessions, Workflows Using Workflow Manager
  • Prepared unit test cases to meet the business requirements and performed unit testing of mappings.
  • Preparing the database scripts for DB objects and execute them in AWS Redshift.
  • Analyze and Tune the Redshift database objects by making use of different performance techniques like distribution keys, sort keys and encoding techniques according to the table requirements.
  • Preparing the design documents (HLD, LLD) and source to target column mapping sheet.
  • Experience in integration of heterogeneous data sources like Oracle, Sybase, SQL
  • Server, Amazon S3 Flat Files into Staging Area using Informatica mappings, workflows and session objects.
  • Development of ETL mappings, sessions and workflows according to the design.
  • Implementing SCD Type - II logic in the mappings for loading the dimensions data.

Environment: SQL Server, Oracle 10g, Informatica Power center 8.6, Oracle SQL developer, Toad, UNIX shell scripts, Autosys.

Confidential, Michigan

ETL Developer

Responsibilities:

  • Worked as a part of a team and provided 24 X 7 support and on-call when required. Involved in gathering the requirements and system specifications from users.
  • Created the Functional specifications, Technical specifications and Use Cases.
  • Developed PL/SQL Packages, Procedures, Functions, Triggers, Views, Indexes, Sequences and Synonyms.
  • Created a new forms and Modified the existing forms and Pro*C programs according to the business logic.
  • Designed and developed Informatica ETL mappings to extract master and transactional data from heterogeneous data feeds and load
  • Installed and Configured the Informatica Client tools.
  • Worked on loading of data from several flat files to XML Targets.
  • Designed the procedures for getting the data from all systems to Data Warehousing system.
  • Created the environment for Staging area, loading the Staging area with data from multiple sources.
  • Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
  • Used workflow manager for session management, database connection management and scheduling of jobs.
  • Involved in Unit testing, Integration, UAT testing.
  • Interacted with end user for problems faced and providing necessary technical support by fixing the bugs.
  • Involved in DBA activities like creating a USER, providing roles, privileges, Grants, Revokes and Locking the User accounts.
  • Guided team in writing the efficient code for different interfaces.
  • Coordinate with different teams while doing production support

Environment: Oracle 10g, PL/SQL,Db2, TOAD 9.5, SQLPLUS, SQL*LOADER, Informatica Power Center 7.1/8.6, UNIX AIX 5.1, Telnet

We'd love your feedback!