We provide IT Staff Augmentation Services!

Sr Etl Developer Resume

Atlanta, GA

SUMMARY:

  • Having 8 years of comprehensive experience in D Confidential Warehouse/ Business Intelligence technologies helping clients align IT strategies with corporate strategic objectives across departments.
  • Extensive experience in Working with Informatica Power Center 10.0 involving designer, Workflow Manager, Work flow Monitor, Repository Manager and developed Source and Target layout, Mappings, Mapplets, Worklets and Transformations.
  • Experience in Performance Tuning using Informatica Partition and push down optimizations.
  • Extensive experience in Ab initio 1.14 with Co - operating system 3.0.5 and ready to work on any latest version.
  • Have Knowledge in d Confidential load into Mongo DB using Informatica Power center.
  • Good experience in developing SQL, PL/SQL Stored Procedures, Packages, Functions, Cursors and Triggers.
  • Extracted d Confidential from Homogenous sources, Heterogeneous sources which includes RDBMS, Flat files - Fixed Width and delimited files.
  • Have Knowledge in slowly changing dimension, star schema and snowflake schema modeling.
  • Extensively worked in UNIX to create and execute scripts and to monitor the behavior of applications running at the back end, perform and monitor load utilities, scheduling through CRONTAB, JAMS.
  • Proven ability in PLSQL and Informatica Deployment group based code movements across Testing and Production environments.
  • Taking care of operations along with usual development activities become a DevOps Engineer.
  • Analyzing STEP 7.4 MDM d Confidential and fixing all junk character issues from STEP 7.4 to STEP 8.3 in the d Confidential migration.
  • Recommended different d Confidential migration techniques to clients for fast moving of d Confidential to STEP 8.3 with in stringent timeline.
  • Focus in the extensive design, coding, testing, implementation and deployment.
  • Having extensive programming skills in Ab Initio ETL tool, PL/SQL, ORACLE and UNIX Shell scripting.
  • Knowledge of various d Confidential bases like DB2, ORACLE, SQL SERVER.
  • Experience in developing complex mappings using Ab Initio to load the d Confidential from various sources into the D Confidential Warehouse.

TECHNICAL SKILLS:

  • ETL Tools
  • Informatica Power Center 10, Ab Initio, Talend and SSIS
  • MDM Tools
  • Stibo STEP 7.4, STEP 8.3
  • D Confidential base
  • Oracle 10g, SQL server, DB2, MongoDB
  • Reporting Tools
  • Tableau, Tibco SpotFire
  • Scripting language
  • Shell scripting, Perl and Python, understand Powershell
  • File Transfer API
  • FTP Tools (Win SCP and File Zilla), Confidential compare
  • Project Management Tools
  • JIRA, HP (ALM/QC), MSTeams
  • Version Control tools
  • SubVersion, PVCS, Ab initio EME
  • Scheduler
  • CRONTAB, JAMS, HEATS (for code migration), HDDTM and Maestro (for job automation)

PROFESSIONAL EXPERIENCE:

Sr ETL Developer

Confidential, Atlanta, GA

Responsibilities:

  • Interaction with the Clients and understand requirements
  • Code and Functionality Walk through to Team.
  • Worked on Informatica power center, SSIS and Talend ETL tools and scheduled them in JAMS.
  • Test d Confidential preparation (D Confidential profiling and d Confidential sampling for specific requirements)
  • Oracle PL/SQL package development and support.
  • Created XMLs/CSV files to Import d Confidential to STEP MDM and Export to various targets.
  • Good experience developing SQL, PL/SQL Stored Procedures, Packages, Functions, Cursors and Triggers.
  • ETL Informatica Power center - Warehouse designer, Workflow Manager, Work flow Monitor, Repository Manager, Source Analyzer and developed Source and Target layout, Mappings, Mapplets and Transformations.
  • Used Transformations as Source, Target, Expressions, Sorter, Union, Aggregator, Update Strategy, Joiner, Filter, Connected/Unconnected Lookups and Router Transformations.
  • Used session partition for performance tuning.
  • Adhoc d Confidential analysis and code fix based on business feedback.
  • Acting as team lead (2 onshore member and 6 member offshore team).
  • Create mapping design for team and mentoring the team.

ETL Developer

Confidential, Chennai

Responsibilities:

  • Develop graphs and UNIX shell scripts for new processes.
  • Submitting maestro tooling requests for the jobs through web UI.
  • Giving an accurate and immediate fix for the Production jobs in case of any issues/failures
  • Writing/executing SQL queries for validation/load purposes
  • Give L3 support in case of failure of jobs in production
  • We give support to the QA team for running of etl jobs in different environment.
  • Solving issues that are related to ETL batch jobs.

ETL Developer

Confidential, Chennai

Responsibilities:

  • Worked closely with the TSBI/ETL Lead to understand the requirements and design of the solution on project start up and followed up with them throughout the development life cycle with issues/queries to provide the expected results.
  • Developed Ab Initio Graphs to Extract/Cleanse/Validate/Transform d Confidential from diverse sources like flat files (fixed length, delimited) based on the mapping rules or business rules given.
  • Developed Ab Initio Graphs/Scripts to create d Confidential warehouse keys using in house surrogate key cutting concepts and cross files linking natural and surrogate keys.
  • Prepared Low Level Design (LLD) documentation and Unit Test Cases.
  • Used tools like PVCS for version control, VSTS for Configuration Management, Defect Tracking.
  • Worked closely with the on-site team for effective On-site-Offshore co-ordination by working on time shifts that overlap with the on-site team.
  • Analysed Source to Stage and Stage to Target mapping document based on Facts & Dimensions and validating the DDL, Counts, Not Nulls, Duplicates, PK & FK validation, business rules to be applied on target tables.
  • Loading of Source and target files from UNIX environment to required schema in DB2 systems.
  • Execution of ETL Jobs like Source file validation, ODS to staging by using UNIX.
  • Used Advanced Query Tool for DB2 in creating and executing SQL Queries for testing ETL process flow.
  • Implemented Iterative and Incremental Agile - Scrum Methodology for rapidly changing or highly emergent requirements and following parallel development.

Hire Now