Shubhabrata Dutta
ROUND ROCK,TX
Summary
Over 20 years of experience in the analysis, development, and implementation of enterprise data solutions, with a proven track record in the Healthcare, Financial Services, Insurance, and Banking sectors. Expertise in ETL design and development supported by more than 15 years of proficiency in Informatica PowerCenter, Informatica Cloud (IICS), and Informatica Data Quality. A strong foundation in Master Data Management, Data Profiling, and Data Quality procedures, complemented by skills in SSIS, Snowflake, and Netezza, enables the creation of robust data warehousing and integration solutions for over a decade. This comprehensive skill set ensures the delivery of high-quality data solutions tailored to meet complex business needs.
Overview
19
19
years of professional experience
Work History
Senior Technical Lead
HCL AMERICA Inc
07.2022 - Current
- Responsible for integrating data into the NETEZZA and SNOWFLAKE Cloud DB by leveraging IBM information server/ DataStage and Informatica PowerCenter software
- Participate in all phases of the development lifecycle from inception through post implementation support
- Develop applications in a high volume ETL tools like Informatica, DBT and using SQL, NETEZZA, SNOWFLAKE, CONTROL-M scheduler
- Optimizing ETL data pipeline performances
- Create reusable ETL objects
- Create data pipeline to load the data from data layers and all the way to DL 3-4 layers
- Create tasks and streams
- Document high level and low-level technical design documents for support use to maintain the applications
- Perform code reviews
- Document all testing results
- Effectively communicate with business to ensure success, perform daily and weekly review with stakeholders by creating reports and high-level technical design
- Work on agile/ scrum methodologies
- Work on Github for code versioning purpose and code deployment purpose using CI/CD pipeline
- Environment: Informatica Power center 10.2/10.5, NETEZZA, UNIX, Squirrel agent, Snowflake DB, SQL SERVER DB, POWERSHELL
Senior Consultant
ATG-COGNIZANT
11.2021 - 06.2022
- Participate in discovery sessions with project teams to understand data requirements needed to support solution implementations.
- Work collaboratively with a project and client team in an agile environment to support our cloud initiatives
- Leverage system and process analysis skills to produce data strategies that create a seamless and uninterrupted experience for our clients.
- Collaborate with clients to generate data mapping documents between target and source systems.
- Leverage industry-leading tools to extract, transform and load data into source systems in an automated fashion to support data migrations.
- Perform data profiling tasks to collect statistics, trends, impacts, and summaries that lead to a structured and successful implementation.
- Provide key insights based on data analytics to aid the client in drawing conclusions as to the business value and impact of their data and best approaches for migrating and transforming data to support new system architectures.
- Work with project management to provide regular status updates to internal and external stakeholders.
- Environment: Salesforce API, Salesforce SOQL, MYSQL, SQL SERVER, PENTAHO DI
Sr. Data Engineer / ETL Developer
RELIABLE SOFTWARE RESOURCES IT
11.2020 - 10.2021
- Participating in data architecture and data integration design discussions
- Collaborating with business partners on data issues
- Partnering with application developers on designs, models and best in class implementation
- Interacting with experts from across Schwab in different support organizations and business groups
- Being a member of Agile team(s) that focuses on delivering what the client needs
- Assisting in design and development of data quality and data drift detection software
- Implementing data integration ETL in Informatica Power Center
- Working closely with DBAs, data analysts, developers, and production support to identify and fix data issues that cross platforms
- Environment: Informatica Power center 10.4.1, ORACLE, SQL SERVER DB, Salesforce data loader, Unix, Jira, Agile
Team lead
HCL/ USAA, TX
11.2020 - 10.2021
- Responsible for design, development, and maintenance of ETL processes to populate warehouse and lead the database analysis, design, and build effort. Also involve in Unit testing and System testing of the individual.
- Worked with developers to design and improve complex SQL queries so they are optimized
- Ensure systems meet a high standard for quality of service by proactively monitoring and tuning systems
- Develop SQL scripts and objects to support application functionality and performance
- Supporting the INFOSCAPE application team on ground to help completing the monthly load smoothly and within SLA
- Helping the team in mitigating any issues while executing the monthly load with help of respective teams and making sure of no delay in completing the load
- Lead MDM requirement analysis sessions. Coordinate MDM program activities for Customer and Product data domains
- Helped MDM team to generate SBR for all active customers in the USAA P&C portfolio
- Environment: Informatica Power center 9.6.1/ 10.1/10.4.1, Informatica MDM, NETEZZA, HADOOP, UNIX, Squirrel agent, Aginity workbench
Sr. ETL Developer/ Data Engineer / Data Modeler
Ascension Technologies, TX
06.2019 - 08.2020
- Develop efficient and high performing ETL solutions using Informatica PowerCenter (Designer, Monitor, Repository Manager & Active Batch Workflow manager). Performance tune complex mappings, transforms, aggregations, joins, enrichment, validations for target data underpinnings.
- Create processes that conduct service calls through APIs that interface with 3rd party applications. Load/extract data from Salesforce.com using IICS. Ensure best practices are adhered to and leveraged while using Informatica Cloud
- Assess and profile source, target data (data structure, quality, completeness, schema, nulls, etc.).
- Summarizes testing and validation results and make recommendations/decisions on best course of action to remediate.
- Support ETL Development Team regarding ETL platform functionality. Work with Job Scheduling team to setup and implement ETL processes. Implement procedures for maintenance, monitoring, backup, recovery operations for ETL environment, includes regular reporting on health and performance of the ETL environment and jobs
- Analyzed the needs of an organization and produce an effective database system according to their needs and specifications
- Executed performance testing procedures to ensure the proper operations of a database and to ensure that it’s error-free
- Wrote documentation about the system and put together an operational manual.
- Worked with the front-end development team to integrate the modules together and test the integrated code and fixed ass errors.
- Environment: Informatica Power center 9.6.1/10.1, SQL SERVER DB, DIMENSIONAL MODELLING, TIDAL, IICS
ETL Architect
ATOS SYNTEL
11.2015 - 05.2019
- Responsible for defining project resources, roles, responsibilities, documenting deliverables catalogue, managing project costs, working with customers, end-users, architects, application designers to define the data requirements and structure for Business Intelligence (BI) applications.
- Responsible for design, development, and maintenance of ETL processes to populate warehouse and lead the database analysis, design, and build effort.
- Documenting a project’s data quality procedures and its outputs using Informatica Data Quality to profile the project source data, define or confirm the definition of the metadata, cleanse and accurately check the project data, check for duplicate or redundant records, and provide information on how to proceed with backend ETL processes
- Collaborate with business and technical teams to gather requirements around data quality rules and propose optimization of these rules if applicable, then design and develop these rules with IDQ
- As per business requirements, perform thorough data profiling with multiple usage patterns, root cause analysis and data cleansing and develop scorecards utilizing Informatica
- Lead MDM requirement analysis sessions. Coordinate MDM program activities for Customer and Product data domains
- Environment: Informatica Power center 10, SSIS, MS SQL SERVER, DB2, UNIX, TERADATA, INFORMATICA IDQ, Informatica MDM, CONTROL-M, ACTIVE BATCH, ORACLE 11g, Oracle EXADATA,T-SQL
ETL Architect
ACCENTURE
06.2014 - 10.2015
- Worked with multiple teams to define data requirements, structure for Business Intelligence (BI) applications.
- Designed models for data warehouse or data mart (data structure, storage, and integration).
- Responsible for design, development, and maintenance of ETL processes to populate warehouse, lead database analysis, design and build effort.
- Used Metadata manager for validating, promoting, importing, exporting repositories from development environment to testing environment
- Worked with developers to design and improve complex SQL queries so they are optimized.
- Worked on various production support activities like mentoring team members on helping them understanding the approach of resolving the P1/P2 tickets is proper way and in quick manner
- Worked on 24
- 7 on-call production support activities including weekends
- Performed disaster recovery tests to ensure system availability and functionality
- Assisted in streamlining processes to reduce and make daily workload more efficient
- Attended daily status meeting to follow-up and resolve outstanding group issues
- Worked on improving job execution performances to meet the SLA timings
- Drove Best Practices, tools and procedures to enhance operations and increase efficiency
- Environment: Informatica Power center 9.5.1, DB2, TOAD, UNIX, DATASTAGE
Team lead
LEVEL3 Communications, HYD, IND
10.2012 - 05.2014
- Responsible for design, development, and maintenance of ETL processes to populate warehouse and lead the database analysis, design, and build effort. Also involve in Unit testing and System testing of the individual.
- Worked with developers to design and improve complex SQL queries so they are optimized
- Used UNIX to create Parameter files and for real time applications. Developed shell scripts.
- Environment: Informatica Power center 9.1.1, DB2, TOAD, PL/SQL, AB INITIO, UNIX, Oracle EXADATA
Team Lead
US STEEL, HYD, IND.
01.2012 - 09.2012
- Responsible for design, development and maintenance of ETL processes to populate warehouse and lead the database analysis, design, and build effort. Involve in Unit testing and System testing of the individual.
- Work on the scheduler tool like DAC (Dynamic Access Controller) to schedule and monitor the Informatica jobs
- Work on reporting tool like OBI and created complex universes through OBI in alignment of the business requirement
- Environment: Informatica Power center 8.6.1, TOAD, PL/SQL, DAC, OBIEE
Sr. ETL Developer
FARMERS INSURANCE, HYD, IND.
10.2010 - 12.2011
- Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations. Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer.
- Designed and improved complex SQL queries so they are optimized and involved in Unit testing, System testing
- Environment: Informatica Power center 8.6.1, PL/SQL, ORACLE SQL
Sr. ETL Developer
IBM Global Services
11.2009 - 09.2010
- Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations. Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer.
- Designed and improved complex SQL queries so they are optimized and involved in Unit testing, System testing
- Environment: Informatica Power center 8.6.1, PL/SQL, ORACLE SQL
Sr. ETL Developer
TATA CONSULTANCY SERVICES
01.2009 - 11.2009
- Created complex mappings in Power Center Designer.
- Worked on scheduler tool like AUTOSYS to schedule and monitor the Informatica jobs
- Environment: Informatica Power center 8.6.1, PL/SQL, AUTOSYS, SQL SERVER, ORACLE SQL, DATASTAGE
ETL developer/ Lead production support executive
Toyota Financial Services, CA
06.2006 - 12.2008
- Created mappings in Power Center Designer.
- Monitored performance, tuned databases, conducted Post deployment analysis on production server for new changes.
- Environment: Informatica Power center 7x,8x,9x, HYPERION SYSTEM 9, AUTOSYS, TOAD, UNIX
Education
Bachelor of Technology - Electronics And Instrumentation
West Bengal University of Technology
India08-2005
Skills
- Database Proficiency: Experienced with multiple database systems including Oracle, SQL Server, and MSAccess across various versions
- Programming and Tools: Skilled in SQL, PL/SQL, TOAD, and SQL Loader for efficient database querying and management
- Job Scheduling Expertise: Proficient with scheduling tools like Autosys, Tidal, and Control-M to manage ETLworkflows and jobs
- Cloud and Integration Skills: Hands-on experience with cloud technologies and APIs, integrating Salesforce via Informatica PowerCenter and IICS
- Data Sources: Salesforce, Oracle, SQL Server, Flat Files, XML
- Informatica IICS, INFORMATICA IDQ, Informatica MDM, Informatica PowerCenter 7x/8x/9x/10x, Autosys, Tableau, Data Warehouse administrative console (DAC), Oracle Business Intelligence (OBI), CONTROL-M, TIDAL, AB-INITIO, SSIS, ERWIN, AWS GLUE, S3, AWS ATHENA, Salesforce data loader, Pentaho DI/ Kettle
- Oracle SQL, PL/SQL, MS SQL SERVER, IBM DB2, NETEZZA, Oracle EXADATA
- AWS, SNOWSQL
- Banking and Financial Services, Insurance, Healthcare
Personal Skills
I am technically competent, detail-oriented and results-driven software professional. I am confident in comprehensibility, verbal and written communication skills. Ability to effectively interact with customers has been my strength. Continuous learning is the key of my success. I believe in hard work and honesty and I like to take challenges. I appreciate open-mindedness to new ideas. My courage to take multiple responsibility and well team-coordination power are real value additions to any company.
Timeline
Senior Technical Lead
HCL AMERICA Inc
07.2022 - Current
Senior Consultant
ATG-COGNIZANT
11.2021 - 06.2022
Sr. Data Engineer / ETL Developer
RELIABLE SOFTWARE RESOURCES IT
11.2020 - 10.2021
Team lead
HCL/ USAA, TX
11.2020 - 10.2021
Sr. ETL Developer/ Data Engineer / Data Modeler
Ascension Technologies, TX
06.2019 - 08.2020
ETL Architect
ATOS SYNTEL
11.2015 - 05.2019
ETL Architect
ACCENTURE
06.2014 - 10.2015
Team lead
LEVEL3 Communications, HYD, IND
10.2012 - 05.2014
Team Lead
US STEEL, HYD, IND.
01.2012 - 09.2012
Sr. ETL Developer
FARMERS INSURANCE, HYD, IND.
10.2010 - 12.2011
Sr. ETL Developer
IBM Global Services
11.2009 - 09.2010
Sr. ETL Developer
TATA CONSULTANCY SERVICES
01.2009 - 11.2009
ETL developer/ Lead production support executive
Toyota Financial Services, CA
06.2006 - 12.2008
Bachelor of Technology - Electronics And Instrumentation
West Bengal University of Technology