We provide IT Staff Augmentation Services!

Sr Etl Programmer Resume

3.00/5 (Submit Your Rating)

Boca Raton, FL

SUMMARY:

  • 8+ years of IT experience in Business Requirement analysis, design, development and implementation of Data warehousing and Business Intelligence applications using ETL.
  • Experience working with Salesforce and CRM using Informatica.
  • Strong technical experience in SDLC including requirement gathering, Design, Analysis, Coding, Testing, Documentation and Deployment.
  • Strong experience in designing and developing Business Intelligence solutions in Data Warehousing/Decision Support Systems using Informatica Power Center.
  • Nature of work emphasizes on Data Warehousing and ETL concepts using Informatica Power Center (Workflow Manager, Workflow monitor, Designer, Source Analyzer, Repository manager), Informatica Power Exchange, MDM concepts.
  • Understanding and working knowledge of Informatica CDC (Change Data Capture).
  • Good knowledge of Relational Databases like SQL Server, Oracle, DB2.
  • Experienced in Logical and Physical Database design & development, Normalization and Data modeling using Erwin and SQL Server Enterprise manager.
  • Experience with slowly changing dimension methodology and slowly growing targets methodologies.
  • Experience in multidimensional modeling and RDBMS concepts Data mart, OLAP, OLTP using Star Schema and Snow - Flake Schema.
  • Good understanding in writing Test plans, Test cases, Unit testing, System testing, Integration testing and Functional testing.
  • Worked on MDM concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
  • MDM Hub configurations - Data modeling, Data Mappings, Data validation, Match and Merge rules, Hierarchy Manager, customizing/configuring Informatica Data Director.
  • Defining and configuring landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages.
  • Designing & developing multiple cleansing and standardization scenarios using Address Doctor.
  • Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
  • Strong experience in InformaticaData Quality (IDQ), Power Center, Data Cleansing, Data profiling, Data quality measurement and Data validation processing
  • Hands on work knowledge on core Informatica MDM Hub components such as Hub Console, Hub Store, Hub Server, Cleanse Match Server and Cleanse Adapter in Windows.
  • Strong Experience on Performance Tuning (source, target, sessions, transformations) and Power Analyzer, Power Exchange, Data Mart.
  • Used Unix Shell scripts to write pmcmd commands to automate workflows.
  • Experience with different scheduling tools to accommodate requisites.
  • Worked on COGNOZ Cube queries, Drill Through reports, Tableau Datamart’s and CRYSTAL report queries as part of BI environment.

TECHNICAL SKILLS:

ETL TOOLS: Informatica 9.5.1 /9.6.1/9.8.1, SSIS 2012

REPORTING TOOLS: Data Profiler, Cognos 8.4/10.1, BX 4.1, SSRS 2012

DATABASES: Oracle 11i/10g, DB2 10.1, MS SQL Server 2012/2008, MS Access, Salesforce

OPERATING SYSTEMS: Microsoft 7/XP/2000/NT, LINUX

DATA MODELLING: ERWIN, Microsoft Visio, Embarcadero ER Studio

SCHEDULING TOOLS: Workflow Manager, ESP, Autosys, TIDAL

QUERYING TOOLS: SQL developer, PL-SQL developer, Toad, Benthic, Hue

PROFESSIONAL EXPERIENCE:

Confidential, Boca Raton, FL

SR ETL Programmer

Responsibilities:

  • Monitor and modify daily & on demand batch jobs dat load warehouse tables from various source systems like Oracle, Sql server, Salesforce.
  • Fix sessions dat result in undesired load data in lower & higher environments for both Data warehouse and DataMart’s.
  • Development on existing mappings dat acquired extended scope to accommodate new logistics and perform regressive testing before migrating it to higher environments.
  • Create views on tables and use stored procs for maximum performance to move data from different source systems across several servers to Data warehouse
  • Work on Linux to use file system for loading tables in all environments.
  • Manage deployment and Informatica server maintenance in lower environments.
  • Identify least performance batch jobs and implement solution to maximize efficiency across all environments.
  • Coordinate with team members to design tables and their flow to generate dashboards and reports.
  • Load and monitor data loads to both Relational Database and Hadoop File system.
  • Implemented Slowly Changing Dimensions (SCD, Both Type 1 & 2) defining the queries and flow through ODS - Warehouse.
  • Communicate with other data teams to identify missing source files and fix the occurrence.

Environment: MS SQL Server 2012,Oracle 11g, Informatica 9.8.1, IDQ, Salesforce, Embarcadero ER Studio, SQL Developer, TOAD, Tableau, Hadoop, TIDAL.

Confidential, Linthicum, MD

ETL Developer

Responsibilities:

  • Work on data integrity, reconciliation to maintain accuracy of data across databases of Carriers like Cigna, Care first, Evergreen, Kaiser Permanente and Marketplace.
  • Develop and maintain etl solutions for 834 EDI and 1095A processes using unstructured transformations, xml schemas.
  • Involved in establishing of Data Quality rules by combining regulatory and application requirements for 1095A and 1095B into business rules using Informatica.
  • Worked on analyzing and Performance tuning queries verifying the Indexes, joins, Query Statistics and Execution plans using Informatica Power Analyzer.
  • Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for SSRS reporting.
  • Communicate with IRS, CMS hub for monthly and yearly exchange of data.
  • Involved in the analysis, design, development, testing, and deployment of complex code to calculate, group, filter, parameterize, and format the contents of the transactional reporting system.
  • Generate and Test Adhoc and operational Reports for collections and loss mitigations Reports like Audit Reports for CSR amounts in SQL Report Builder using SSRS.
  • Worked closely with DB2 and SQL Server DBA teams to regularly monitor Batch loads for bottlenecks and implement appropriate solutions for performance.

Environment: MS SQL Server 2012, Informatica 9.6.1, IDQ, SSRS 2012, DB2 10.5, Microsoft Visual Studio 2008, Erwin, SQL Developer, Db Visualizer, Windows XP, MS Office, MS Access.

Confidential, Harrisburg,PA

Datawarehouse Developer

Responsibilities:

  • Played a pivotal role in requirement gathering with users, meeting various representatives from different Program Offices.
  • Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models using Erwin.
  • Carried thorough validation of database model and helped in designing ETL strategy.
  • Worked on getting the data loaded into the landing tables and staging tables with required Informatica transformations.
  • Worked closely with business users to understand the Data lineage and DQ framework and develop queries dat can be used for over and under Matching to bundle up duplicate presence.
  • Automated crucial NCANDS reports and PSA reports for federal reports using Cognos.
  • Involved in creating jobs and alerts and scheduling it on daily, weekly and monthly bases using Informatica.
  • Verified Crystal reports created on weekly basis and held technical meetings to reduce inappropriate data.
  • Responsible for developing ETL packages to load dimension, fact and summary tables.
  • Involved in Performance tuning by determining bottlenecks in sources, mappings and sessions and validating SQL tuning, dbms stats, explain plan, SQL trace.
  • Created logical and Physical database design, data structures, primary key, foreign key and implemented large databases using Erwin.
  • Review reports to determine basic characteristics - origin, report flow, format, frequency, distribution, purpose by generating Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using Cognos, Business Objects.
  • Deployed packages, folders and Reports from a development environment to Testing environment and Production environment.

Environment: Windows Server 2010, Informatica 9.5.1,MDM, Cognos 8.4, BX 4.1, Oracle 11i,DB2 10.5,Java-J2EE Microsoft Visual Studio 2008, Erwin, PL-SQL Developer, Linux.

Confidential

INFORMATICA DEVELOPER

Responsibilities:

  • Developed workflows and dataflow using business logic.
  • Used Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools, worked with high volume databases with partitioned data.
  • Importing metadata from various sources flat files, xml and sql server.
  • Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
  • Maintained details of ETL packages using repository manager query tool.
  • Responsible for elevating and automating successful code to production environment.
  • Created complex Mappings using union, xml, lookup, router, transaction control, aggregator, sorter and sql transformations.
  • Worked on ETL (Extraction Transformation Loading) architecture for overall data transfer from the OLTP to OLAP.
  • Worked on warranty Program change requests in timely limit to make the schedule run on time.
  • Involved in the analysis, design, development, testing, and deployment and used complex expressions to calculate, group, filter, parameterize, and format the contents of the transactional reporting system.
  • Wrote sql queries for obtaining data in combinations of various environments based on report query logic, validation scripts, file archive scripts, mailing scripts.
  • Designed ETL Process using Informatica to load data from Flat Files, and Excel Files to target Oracle Data Warehouse database.

ENVIRONMENT: Informatica Power Center 8.1, Informatica Power Analyzer, Mainframe,DB2, Erwin, TOAD, Business Objects XI, SQL Developer, windows NT/XP, Db2, flat files, xml files and windows 2000.

We'd love your feedback!