We provide IT Staff Augmentation Services!

Sr Etl Developer Resume

SUMMARY:

  • 14+ years of extensive experience in Information Technology SDLC (Software Development Life Cycle) with a strong background in Database development, Data warehousing, strong experience in Data Integration, Migration and ETL process using Informatica Power Center, IDQ, B2B DT, CDC Axway B2B DT, Sentinel.
  • Involved in functional and technical Systems Analysis & Design, Systems architectural design, presentation, process data flow design system impact analysis, star schema, and snowflake, changing dimension, Gap analysis and documentation.
  • Strong experience in Application Production Support and Maintenance.
  • Experience in End - to-End Database Development, Performance Tuning, Optimization of SQL.
  • Strong experience in Data Analysis.
  • Experience in supporting webservices applications.
  • Experience in supporting Admin activities for SAS, Tableau and COUPA applications.
  • Experience in integration of various Operational Data Source (ODS) with Multiple Relational Databases like Oracle, SQL Server and Worked on integrating data from flat files.
  • Experience in MFT using Axway file transfers tool.
  • Good knowledge of Data modeling techniques like Dimensional/ Star Schema, Snowflake modeling, slowly changing Dimensions and CDC.
  • Experience in testing coordination, writing test cases and executing test scripts, and logged defects in HP Quality Center (ALM)
  • Hands on experience in UNIX & LINUX work environment, including transfer of files, scheduling of jobs and error handling.
  • Experience in leading a team of developers.
  • Experience working in Agile / Scrum methodologies.

TECHNICAL SKILLS:

ETL Tools: Informatica 10.x/9.x8.x/7. x. IDQ. Power Exchange CDC, B2B DT, TDMAXWAY B2B DT

Data Modelling: Erwin

Databases: Oracle 11G/10G/9i, SQL Server 2012, DB2, Teradata 14/13,MongoDB

DB Tools: SQL *Plus, SQL *Loader, TOAD, IBM Data Studio, PL/SQL Developer, SSMS

Reporting: Sentinel, SSRS,SAS,TABLEAU

Languages: C, C++, Java, COBOL, PL/SQL

Scheduling Tools: Tidal, Control M, Tivoli, AutoSys

Version Control: SVN, PVCS,GIT

Testing Tools: HP ALM

Platforms: WINDOWS, UNIX, LINUX

EXPERIENCE:

Sr ETL Developer

Confidential

Responsibilities:

  • Worked on loading earning files from different source systems into Relational Targets using Informatica for Insurance reconciliation.
  • Created XML files using Informatica and SFTP to downstream locations.
  • Coordinate with all application teams and built Informatica solutions,
  • Worked in Informatica ILM to archive 30 TB database.
  • Resolve L1 and L2 Application Issues and Fulfill L1 and L2 Application Service Requests.
  • Maintain environment availability e.g., OS upgrades, patches, etc. Application health check and Recommendation report Application version upgrades and Management.
  • SMG3 Exception in carLOS environment - Redeploy atb.war/cap.war in weblogic server in corresponding domain.
  • Monitor SMG3, IODS daily and monthly batch processing.
  • Involved with Risk Data Science Team to develop a TFS in house-built Risk Decision Engine to evaluate the Origination Applications and develop a replacement for SMG3 DE.
  • Supporting new Zuul Decision Engine, A web service that produces a custom credit score based upon input data posted in the web call.
  • Storage Allocation to SMG3 databases, Database cleanup for SMG3 Production database - purging the backup tables and the tables that are no longer in use in SMG3 batch processing.
  • Create problem records and Perform initial RCA.
  • Provide access for applications not managed by Access Admin team, ERA responsible for providing access to Tableau, SAS, COUPA and maintaining TMNA AD group for TMNA Tableau users.
  • Identify and implement operational automation opportunities.
  • Worked on Informatica enhancements and performance tuning.
  • Worked on Informatica 10.2 Upgrade testing.
  • Worked on Enterprise Data catalogs using Steerwise and AXON.
  • Creation of KB scripts for Service Desk use.

Environment: Informatica 10.2,Informatica AXON, Steerwise DSA,Oracle11g, GIT, ServiceNow, JIRA, AutoSys, Linux /UNIX, SAS, TABLEAU, COUPA.

Developer Advisor

Confidential

Responsibilities:

  • Development lead for ACMP 1.0 proof of concept, this was a migration of the existing ACMP reporting table data to warehouse over to GBD operational data warehouse.
  • Developed complex analytic SQL code for reporting as part of CMOS PDM (post discharge management). Worked closely with the business to define business rules and troubleshoot data issues.
  • Converted PDM Stored procedure into ETL code as part of performance tuning.
  • Extensively worked on Informatica Designer 9.5.1/10.2 on source analyzer, target designer, transformation developer, mapplet designer and mapping designer.
  • Extensively involved in designing Data Extraction and Loading (ETL) process from source to target using Informatica Power Center.
  • Loaded the third-party vendor health care eligibility files into internal staging tables using informatica mappings.
  • Developed mappings for multiple inbound jobs (into internal ODS tables) and outbound jobs (outside vendors) extracts.
  • Extensively used transformations like Lookups, Update strategy, joiner, Router and Stored Procedure during mapping development.
  • Created Reusable transformations, mapplets and user defined functions.
  • Extensively worked on SSMS to read and write the data. Designed complex queries.
  • Involve in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.
  • Lead developer for Agile team of four developers working on informatica upgrade. Assisting with design and planning.
  • Experience in deployment process including, creating tickets in JIRA, check-in code in SVN.
  • Created TIDAL jobs for automating ETL jobs.

Environment: Informatica 10.2/9.6, SQL Server 2012, DB2, SVN, JIRA, TIDAL, WINDOWS.

Developer Advisor

Confidential

Responsibilities:

  • Experienced in Informatica data quality (IDQ), power center, data cleansing, data profiling, data quality measurement and data validation processing.
  • Creating the Profiles, scorecards, custom rules and tables using IDQ.
  • Worked on Extraction, Transformation and Loading of data using Informatica.
  • Experienced with AXWAY B2Bi environment and understanding of AXWAY protocols MFT, FTP and SFTP.
  • Experience in setting up trading partners for AXWAY B2B DT.
  • Created Axway mapping services to load EDI X12, flat files and HL7.
  • Setting up connectors like FTP, FILE, EMAIL, HTTP, MQ, JMS & VAN mailbox for receive/send activities.
  • Integrate SQL queries within maps to derive values from customer cross tables. e.g., charge code conversion or list of service types.
  • Created correlation rules to send email notification on MFT.
  • Created Sentinel Dash board track File Transfers.
  • Configured correlation rules in Sentinel to notify customer if there is any delay in Essential files.
  • Created Tidal jobs to automate extracts.

Environment: Axway B2B DT, Sentinel, Informatica 9.x, IDQ, TDM, SQL Server 2008, JIRA, SVN TIDAL

Developer Advisor

Confidential

Responsibilities:

  • Maintaining and/or creating all relevant documentation including but not limited to documents supporting change management process and procedures, job run book, data backup and retention policy, and applicable access controls documentation.
  • Monitor system integrity through daily system checks, to ensure a high standard of service is provided to clients.
  • Daily monitoring and tracking of incoming vendor files to ensure they meet Service Level Agreement (SLA).
  • Monitored Tidal and Informatica nightly jobs and make sure to complete on time within SLA. Escalate issues and remediation steps effectively and in a timely manner.
  • Perform troubleshooting analysis and resolution of critical applications and batch processes.
  • Ensure Real-time Claim processing system available 24*7 and make sure the transaction is processed with in SLA.
  • Support the Client Reporting Production Environment as a priority.
  • Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
  • Experience in using Automation Scheduling tools like Tidal.
  • Involved in design, development and implementation of ETL process in power center. Responsible for managing, scheduling and monitoring the workflow sessions.
  • Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
  • Created Unit Test Cases and documented the Unit Test Results.
  • Provided excellent support during QA/UAT/Beta testing by working with multiple groups

Environment: Informatica 9.x, Tidal, SQL server 2010, Oracle.

Programmer Analyst

Confidential

Responsibilities:

  • Created Design documents such as the source to target Data Mapping document.
  • Experience in dealing with Pharmacy, dental and vision claim files.
  • Experience working with XML sources and target.
  • Actively involved in Data validations and unit testing to make sure data is properly populated in XML files.
  • Experience working with Fixed width and delimited flat files.
  • Extensively worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters.
  • Experience in HIPAA validation levels 1 thru 7 using FacilEdi compliance x12 exchange tool.
  • Subject Matter Expert in Vendor Load Management (VLM) file loads in ODW.
  • Subject Matter Expert in Express Scripts (ESI) pharmacy claims data loads.
  • Prepared monthly reports for tracking vendor files through SSRS.

Environment: Informatica 8.x, DT/DX, SQL Server 2005, Oracle 9i, Tidal.

Programmer Analyst

Confidential

Responsibilities:

  • Experience in Informatica B2B Data Transformation (DT), Data Exchange (DX) and Power Center (PC).
  • Created Informatica mappings to process unstructured data using Data Transformation.
  • Used major components like Serializers, Parsers, Mappers and Streamers in Data Transformation Studio for conversion of XML files to other formats.
  • Experience in creating ETL code to process HIPAA 5010 files using Informatica B2B DT.
  • Experience to load excel files using Informatica B2B DT.
  • Experience in loading 837P, 837D, 837I files using Informatica B2B DT.
  • Involved in documenting EDIs according to code set X12 835 claim payments and remittance advice claims processing.
  • Validate EDI Claim Process according to HIPAA compliance.
  • Involved in HIPAA regulations in Facets HIPAA privacy module.
  • Experience in handling FACETS Claims management data.
  • Experience in automation of file transfers using Informatica DX.
  • Participated in regular discussions with the Facets team to enter test data.
  • Worked on tidal scheduling tool, created groups/jobs in build environment and migrated the respective groups to higher environments for automation run of developed jobs through Tidal.

Environment: Informatica 8.x, DT/DX, SQL Server 2005, Oracle 9i, Tidal.

ETL Developer

Confidential

Responsibilities:

  • Analyzed the relationship between different Clarity tables in Teradata,
  • Closely worked with Data modelers and business analysts to understand the requirements for the Data mart.
  • Extensively worked with SCD Type-I, Type-II and Type-III dimensions and data warehousing Change Data Capture (CDC).
  • Designed Late Arriving Dimension load strategy as per the requirements.
  • Parameterized the code for regional load.
  • Integrated data from Flat files and other Databases to load into Oracle tables using Informatica
  • Developed UNIX Shell scripts for validating the files, running stored procedures & Informatica workflows.
  • Created test plans and executed test scripts in HP Mercury QC (ALM).

Environment: Informatica 7, Power Exchange CDC Teradata, Oracle 10, Tivoli, UNIX, HP QC (ALM).

Database Developer

Confidential

Responsibilities:

  • Design, develop and test new and existing databases.
  • Developed stored procedures, tables, views, scripts, etc., for processing data.
  • Perform ad-hoc analysis of production data where necessary to develop solutions to reported incidents.
  • Work with development and IT teams to troubleshoot data or performance problems.
  • Maintain, update and monitor the existing database on daily basis.
  • Created UNIX scripts to call Informatica from Contrl M.
  • Created and scheduled jobs in Control M.
  • Experience in check-in the code in PVCS version control tool.

Environment: Informatica 7.x, SQL server 2000, Oracle 9i, UNIX, Control M, PVCS

Hire Now