Informatica Developer Etl

Location:

Houston, TX

Posted:

July 19, 2021

Contact this candidate

Resume:

Professional Summary:

Over * years of experience in IT industry as a SQL Server Developer with specialized skills in SSIS, SSAS and SSRS.

Experience in Mapping Server/parallel Jobs in Data Stage to populate tables in Data warehouse.

Expert at developing ETL interfaces using SSIS, Data marts/cubes using SSAS and enterprise reports using SSRS utilizing latest versions (2005/2008) & features.

Experienced in all the stages of Software Development Life Cycle and in the migration and up gradation of databases.

Extensively worked on OLTP Relational Schema with Normalization and OLAP Dimensional Modeling using Star and Snowflake schema.

Experience of Data Migration, ETL or data integration projects and ability to design and execute Data Migration plans.

Experience with self-service BI tools, designing and Developing Dashboards using Tableau.

Created Indexes, Views, Index views, Constraints, Stored Procedure, User-Defined functions, CTEs, and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency.

Create visuals quickly and switch between types easily to find the model that best represents the message using Tableau.

Experience in the planning and delivering of complex data migration between systems.

Provide technical documentation of the data migration project for different clients.

Experience in Error Handling and Debugging packages using Checkpoints, Data Viewers, Breakpoints, Event Handlers and Loggings (SSIS or Custom Loggings) and securing packages secured packages with Encryption in conjunction with passwords.

Involved in writing complex Stored Procedures, Functions, Views, Triggers, and Cursors for various business applications.

Experience in using XMLA protocol for SQL Server Analysis Services 2005 for interaction between client application and instance of Analysis Services.

Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.

Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV’s, DMFs and Query Execution Plans.

Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS/DTS, Import, Export Data, Bulk Insert and BCP utilities.

Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-

ups, Conditional Splits and Event Handlers etc.

Experience in conversion of packages from legacy systems (DTS SSIS) and migrating, deploying the packages across Dev/UAT/Prod environments.

Expert in pytting process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.

Healthcare systems data migration and/or deployment experience.

Created various SSRS Reports involving variety of features like Reports, Charts, Filters, Sub-Reports, Drilldown, Drill-Through, Multi-valued parameters etc.

Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.

Ability to work on multiple tasks in fast paced environment independently and in a team.

Excellent analytical/Communication Skills, Team Play and very much result Oriented.

Technical Skills:

Operating systems

Windows 98/NT/2000/XP/Vista/Windows7/8

Databases

MS SQL Server 2000/2005/2008/2012, MS Access

Database Tools

SQL Enterprise Manager, SQL Profiler, DTS Import/Export, SQL Client Configuration utility, Backup Server, Replication Server, OLAP Services, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS)

ETL Tools

DTS, SQL Server Integration Services, SQL Server Analysis

Reporting Tools

SSRS, Crystal Reports, Congo’s, Micro Strategy

Development Skills

Transact SQL (T-SQL), PL/SQL

Languages

C, C++, HTML, XML, VB.Net, Asp.Net(C#)

Application Packages

Microsoft Office Suite

Education:

Bachelor of Technology in Computer Science from JNTU University, Hyderabad, 2012.

MSEE, Northwestern Polytechnic University, California, 2015.

MSITM, Campbellsville University, Kentucky, 2019.

Certifications:

MCSE-DP : Data Platform Solutions Expert

070-464 : Developing Microsoft SQL Server Databases

MCSM/MCSE-BI : Business Intelligence Solutions Expert

070-467 : Designing Business Intelligence Solutions with Microsoft SQL Server

PROFESSIONAL EXPERIENCE:

Ryder Supply Chain, Miami, FL September 2019 to Present

Role: SQL/ETL/SSIS/Informatica Developer

Ryder operates behind the scenes, managing critical fleet, transportation and supply chain functions for

over 50,000 customers, many of which make the products that consumers use every day. When you

choose Ryder, you get access to industry-leading technology, one of North America’s largest fleet of

trucks, an expansive infrastructure of maintenance facilities and warehouses, and some of the most

talented people in the industry.

Roles and Responsibilities:

Excellent skills in High Level Design of and implementing ETL packages using SSIS 2012/2008/2005

for integrating data using OLE DB connection from heterogeneous sources Excel, DB2,Teradata, CSV, XML, Oracle, flat file, Text file by using multiple transformations available in SSIS toolbox such as Script task, Slowly Changing Dimensions, Data Conversion, Conditional Split, Bulk Insert, Merge, Fuzzy Lookup, Multicast, Lookup and Union all.

Developed, Deployed, and supported complex SSIS Packages for Data Migration and Transferring Oracle/Access/Excel Sheets using SQL Server SSIS.

Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as

Tables, T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, CTEs, Views and Cursors.

Monitored performance of SQL Server, diagnosed the causes of poor queries, solved them by optimizing

or tuning SQL.

Created Slowly Changing Dimension SCD Type 2 mappings for developing the dimensions to maintain the complete historical data.

Hands on experience using Informatica Power Center 9.1

Expertise in designing and developing Informatica mappings from varied transformation logic using

filter, expression, rank, router, aggregator, joiner, lookup, and update strategy.

Expertise in Developing Mappings, Define Workflows Tasks, Monitoring Sessions, Export Import Mappings

and Workflows and Backup, Recovery.

Designed and developed ETL jobs by Using Informatica as ETL tool.

Developed Mappings that extract data to Data Warehouse and monitored the Daily, Weekly, Monthly and Quarterly Loads.

Used existing ETL standards to develop these mappings.

Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, timer and scheduling of the workflow.

Excellent interpersonal and communication skills and is experienced in working with senior level

managers, busines people and developers across multiple disciplines.

Able to develop ETL pipelines in and out of data warehouse using combination of Python and Snowflake’s SnowSQL

In-depth knowledge of Snowflake Database, Schema and Table structures.

Develop stored procedures/views in Snowflake and use in Talend for loading Dimensions and Facts.

Ability to write SQL queries against Snowflake. Also, converted the SQL Server Stored procedures and views to work with Snowflake.

Environment: SQL Server 2008/2012/2014/2016 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), OLTP,

Informatica Power center 9.x, Snowflake

Stericycle, Houston, TX Januray 2018 to August 2019

Role: SQL/ETL/SSIS/SSRS Developer

Stericycle is a compliance company that specializes in collecting and disposing regulated substances, such as medical waste and sharps, pharmaceuticals, hazardous waste, and providing services for recalled and expired goods. Stericycle, Inc., together with its subsidiaries, offers regulated waste management services, sharps disposal containers to reduce the risk of needlesticks, healthcare compliance services, pharmaceutical disposal, and regulated returns management services for expired or recalled products through incineration processes.

Roles and Responsibilities:

Estimated business requirements, created data strategies, and prepared a production implementation roadmap done through detailed understanding

Designed and developed the single design template for the EDV

Source data/ target data/ Metadata/ Reference Data/ model analysis and review

Worked closely with SME’s and data modelers for designing and developing critical components using SSIS

Planned and assigned assignments for the team on a scheduled basis by dividing the workload to optimize code delivery effort.

Identifying the data migration impact of all proposed changes.

Executed data migration in coordination with management and technical services personnel.

Experience in DTS packages migration and creating complex SSIS for ETL purposes including data migration, data extraction/transformation/loading (ETL).

Created Stored Procedures, user-defined functions, views for handling business logic and functionality such as Email Alerts, Data Extracts build-in Excel.

Manage end-to-end complex data migration, conversion and data modeling.

Involved in designing, developing and testing of the ETL strategy to populate the data from various source systems using SSIS.

Work with various source data formats such as Oracle, SQL server, MS Access, MS Excel, and ASCII text files to extract relevant data and migrate to Stericycle’s CRM Application.

Design and implement a table partitioning on a very large databases to maximize scale and performance of VLDBs and tuned much more granularly than smaller databases

Used TFS (Team Foundation Server) for code check-in and check-out and manage different versions of complicated code and distribute them to different teams in the organization.

Designed and Implemented the Extraction, Transformation, and Load (ETL) techniques built using MS SQL Server and Unix Shell Scripting.

Created automation test scripts for web and client server applications.

Developed Performance tuned SSIS codes that decreased a considerable amount of the code run time using.

Optimized packages by avoiding use of non-blocking transformation, executing tasks in parallel and optimizing code at source.

Added XML configuration files to each package to deal with different servers like Development, Testing and Production.

Deployed SSRS reports to the reporting server and assisted in troubleshooting deployment problems.

Developed and Reviewed design documents, test plans, user documentations and promotion documents prepared by the team.

Analyzed volumes from source systems, throughput, generated Table volumetric data and data flow size estimates.

Communicated with various levels of the organization (Executive, Business partners, Project managers, Data modelers, DBA’s, Testing team members, peers, etc.)

Environment: SQL Server 2008/2012/2014/2016 Enterprise Edition, .Net 3.5, SQL BI Suite (SSAS, SSIS, SSRS), OLTP, OLAP, Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access 2013 & Windows Server 2008 R2/ 2012 R2/ 2016.

Equian, Louisville, Kentucky Septemeber 2016 to December 2017

Role: SQL/ETL/SSIS/SSRS Developer

At Equian, efforts are dedicated to addressing the rising cost and affordability of healthcare challenge and provide solutions that ensure each healthcare interaction is paid accurately and at the lowest possible cost. Equian has a proven system to reduce healthcare cost through proprietary data analytics coupled with deep domain expertise. Once it has aligned with the customer and analyzed all the data, it provides integrated payment integrity solutions that eliminate unnecessary spending.

Roles and Responsibilities:

Data warehouse design using Top-down and bottom-up and Data Mart design using Star Schema and Snow-Flake schema.

Responsible for data analysis, data designing, data mapping, data quality, business and MDR (Minimum data requirements) gathering, Technical Specification writing, project management.

Worked on Data migration, conversion, and data modelling

Design and implement new BI/reporting solutions as per requirements gathered with business stakeholders.

Responsible for making weekly backup databases by using SQL Server 2012 and restore these databases in different server.

Design the validation process for conversion//migration using BODS for data accuracy and consistency.

Prepared standard design documents FD, Technical Specification TD, ETL Specifications and Migration documents.

Created tabular models and reports that retrieve data and aggregates directly from a relational database system, using Direct Query mode.

Implemented Master/Child Packages, so only the Master Package has to be scheduled which will in turn fire the other packages.

Created Sequence in SQL Server 2012 to insert same identity value in multiple dimension tables as per the business rules.

Knowledge of data transformations and data migration design and implementation principles.

Handled Performance Tuning and Optimization on SSIS, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.

Supported Business Intelligence, Data Warehouse bug fixing and daily money imbalance tickets.

Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.

Data Investigation and reporting – Extract data from operational systems and reporting databases using a variety of tools, including SSIS. Worked on identifying relationships within the data and between databases, understands requirements of the customer, and the location of required data.

Formulated a comprehensive data migration plan with different conversion strategies, detailed object and field mappings including its transformations and business rules for converting legacy data from SQL Server into Oracle.

Prepared documentation of methods, business requirements, SQL coding, and reporting criteria to a level consistent with departmental standards.

Performed Data integrity, validation and testing on the data migrated into the data warehouse.

Handled all the deployments using TFS from development to production servers using Footprint ticketing tool.

Worked on generating monthly renewals after the month end load.

Written various T-SQL scripts to check whether data is ready from different sources and to view database tables log that accessed last time.

Involved in debugging of packages with help of Breakpoints, Checkpoints, Event Handlers and Loggings.

Deployed SSRS reports to the reporting server in SharePoint Integrated mode and assisted in troubleshooting deployment problems.

Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.

Created several reports using SSRS like drill through reports, linked and sub reports.

Environment: SQL Server 2005/2008/2012 Enterprise Edition, .Net 3.5, SQL BI Suite (SSAS, SSIS, SSRS), OLTP, OLAP, Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003, Oracle, Crystal Reports, Cogon's, Business Objects, SharePoint, MOSS 2007

Weltman Weinberg & Reis (WWR), Cleveland, Ohio April 2015 to July 2016

Role: SQL/ETL/SSIS/SSRS Developer

WWR has Full-service bankruptcy, consumer and commercial collection, compliance, litigation and real estate default services. It has experienced representation in retail, real estate default, commercial and collection matters involving bankruptcy, foreclosure, evictions, probate recovery, compliance & defense litigation, collection recovery, collection litigation & post-judgment executions, complex collections & litigation, contract review, insurance subrogation, and corporate & financial services

Roles and Responsibilities:

Created and refined the performance of various SQL scripts and stored procedures by using UDFs, CTEs and System stored procedures along with usage of tools like SQL Profiler and Database Tuning Advisor (DTA).

Creation and debugging of stored procedures, Indexes, Triggers, Views, User Defined Functions and Cursors

Worked on the Optimization and restructuring of stored procedures for the application by evaluating indexing and partitioning large tables.

Involved in complete Software Development Life Cycle (SDLC), which includes requirement gathering, analysis, design, development, and Implementation

Used various script tasks, look up transformations, control flow tasks like FTP, bulk insert pri, transfer job task etc. and different data flow tasks using T- SQL and Visual Basic (VB) scripts

Created SSIS Packages using the concepts of incremental loading and slowly changing dimensions

Conversion / Migration of SQL Server 2005 to SQL Server 2008 and Reports from SSRS 2005 to 2008

Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.

Used DTS/SSIS for ETL processes, SSRS for Reporting needs and SSAS for Analytics reporting including SharePoint integration

Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.

Involved in writing MDX queries and performance optimization of the SSAS cubes for calculated members and measure groups.

Designed XML stages for reading XML log files for capturing data stage jobs audit data.

Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).

Created Parameterized, Cross-Tab, Drill Down & Drill Through reports by using SSRS 2005/2008

Extensively used stages available to redesign Data Stage jobs for performing the required integration.

Created and scheduled SSIS packages to pull data from SQL Server database and export the data to various data sources like excel spreadsheets, flat file etc. and vice versa

Implemented free text parser for FTP and web data feed in C# .Net

Generated Custom ETL scripts using SSIS 2005 and unit test SSIS load processes for performance check.

Used the ETL Data Stage Director to schedule and running the jobs, testing and debugging its components & monitoring performance statistics.

Ironside, Lexington, MA January 2014 to February 2015

Role: SQL/SSAS/SSIS/SSRS Developer

Ironside is a leading innovator in the rapidly evolving world of business analytics, help organizations ranging from Fortune 500 members to startups solve core business challenges through best-of-breed analytics technology. To meet the diverse needs of the clients, it specializes in all facets of business analytics, including business intelligence, performance management, predictive analytics, information management, big data, and more.

Roles and Responsibilities:

Created and managed stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies.

Project involved maintenance of existing OLTP databases as well as designing SSIS packages for custom warehousing needs.

Involved in the data analysis and database modeling of both OLTP and OLAP environment.

Involved in extracting the data using SSIS from OLTP to OLAP.

Used ProClarity for accessing and analyzing cubes and dimensions and also worked on integration of SharePoint with SSRS.

Created complex stored procedures to perform Index maintenance, data profiling, metadata search, critical staging procedures for loading data marts and reporting database.

Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components, error handling.

Created Sequence in SQL Server 2012 to insert same identity value in multiple dimension tables as per the business rules.

Created SSISDB catalog with SQL Server 2012 to support SSIS package deployments in SSMS with Environment variables respective to each environment.

Generated Custom ETL scripts using SSIS 2005 and unit test SSIS load processes for performance check.

Created various complex reports and manage those using SQL Server Reporting Services (SSRS 2008/2005) according to ERLC.

Involved in migration and Conversion of Reports from SSRS 2005 to 2008.

Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.

Highly involved in creating, structuring, formatting using Report Designer and Report Builder.

Wrote and integrated stored procedures to generate the special reports according to client’s need.

Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007, Share point.

Environment:

SQL Server 2005/2008, BIDS 2005, Reporting services 2005, Integration Services 2005, Analysis Services 2005, Windows Server 2003, Informatica, HealthCare database, Oracle 9i, 10g, DB2, TFS

Contact this candidate