H ABDUL

Sr. ETL Developer David@[Link]

+1 732-860-1575

Professional Summary
 10+ years of experience as an ETL Developer, specializing in data integration,
transformation, and warehousing.
 Demonstrated proficiency in Azure cloud services, with a focus on Azure Data Factory and
Azure Databricks, with over 2 years of hands-on experience.
 Spearheaded ETL development using Snap Logic for over 2 years, streamlining data
integration processes and ensuring data accuracy.
 Extensive expertise in designing, developing, and maintaining ETL pipelines using AWS
Cloud tools, Azure services, and Snowflake.
 Specializing in Informatica, AWS, and SnapLogic. Adept at designing and implementing
ETL processes, optimizing data workflows, and ensuring seamless data integration.
 Proficient in leveraging Curam for social program management, including configuration,
customization, and integration with enterprise systems.
 Leveraged IICS connectors to integrate with a wide range of cloud and on-premises data
repositories, facilitating seamless data flow across heterogeneous systems.
 Excellent knowledge of studying the data dependencies using Metadata of Data Stage
 Developed ETL processes using Snowflake's built-in features and SQL, ensuring data
accuracy and consistency.
 Proficient in Snowflake, SQL, and ETL tools such as [mention specific tools].
 Advanced proficiency in designing and implementing interactive dashboards, reports, and
analytics using MicroStrategy, empowering stakeholders with real-time business insights.
 Proven ability to work collaboratively with cross-functional teams and communicate
technical concepts to non-technical stakeholders.
 Designed, developed, and deployed ETL pipelines within Azure Data Factory, ensuring
efficient data extraction, transformation, and loading processes.
 Sequences for the existing jobs to facilitate scheduling of multiple jobs.
 Implemented advanced data quality and data governance features in IICS to maintain data
accuracy and integrity throughout the ETL process.
 Experience in programming using SQL and Unix Shell Programming/Scripting.
 Good Knowledge in Data Warehousing concepts, Dimensional Modeling, Star Schema and
Snowflakes schema methodologies, Dimensional and Fact tables.
 Skilled in data modeling, database design, and query optimization.
 Created and maintained data pipelines, ensuring data integrity and reliability for analytics
and reporting purposes.
 Oracle data warehousing and Business Intelligence: Data modelling in Dimensional
structures - Star/Snowflake schema, ETL, OLAP, OLTP, VLDB very large application.
 Expertise Debugging Stored Procedures, Triggers, Cursors and SQL coding.
 Analyze data using Python libraries such as NumPy, Pandas, and SciPy.
 Complete understanding of regular matching, fuzzy logic and deduce limitations on IDQ
suite.
 Strong analytical and problem-solving skills with a keen attention to detail.
 Excellent communication and collaboration abilities, working effectively in cross-
functional teams.
 Database experience using Oracle, MS SQL Server, Teradata, Snowflake, Azure Sql
Synapse. Also used SQL Editors such as SQL PLUS, SQL Analyzer and TOAD.
  Strong experience in UNIX scripting and running Data Stage jobs using UNIX scripts.
 Adept at working in fast-paced environments, delivering high-quality solutions on time and
within budget.

Skills:
 ETL Tools: AWS Glue, Azure Data Factory, Snap logic
 Cloud Platforms: AWS, Azure
 Data Warehousing: Snowflake
 Programming Languages: SQL, Python
 Data Modeling: ERD, Dimensional Modeling
 Database Technologies: Amazon Redshift, SQL Server
 Data Integration: Data Transformation, Data Cleansing
 Data Analysis: Data Profiling, Data Validation
 Communication: Team Collaboration, Documentation
 Web Programming:HTML 5, CSS3, Restful API, HTTP, JavaScript, JSON, XML

PROFESSIONAL EXPERIENCE:

Beacon Health Options, Boston, Massachusetts Dec 2020 – Present

Sr. ETL Snowflake Developer
Responsibility:
• Implementing data quality checks and validation processes to identify and rectify data
• Transforming and cleansing the extracted data to ensure accuracy and consistency.
• Implementing data transformation logic using Informatica transformations like
aggregations, joins, and lookups.
• Utilizing Power Query in Power BI for data transformation, such as merging, filtering,
and shaping data for reporting.
• Loading transformed data into the target data warehouse, data mart and reporting
database.
• Ensuring data loads are scheduled and automated for timely updates.
• Used Informatica Power Center for data loading tasks, including incremental data loads.
• Led the integration of Curam modules with existing enterprise systems, streamlining
eligibility determination processes.
• Worked extensively with AWS cloud environment (S3, EC2, Aurora) to develop scalable
and reliable ETL solutions, optimizing data transfer and storage.
• Led the design, development, and deployment of ETL processes using Informatica and
SnapLogic, ensuring efficient data extraction, transformation, and loading.
• Leveraged Azure Databricks for advanced data processing, including data cleansing,
aggregation, and machine learning, enhancing data quality and insights.
• Developed interactive dashboards and reports using MicroStrategy to visualize key
performance indicators (KPIs) and business metrics.
• Worked on IICS Data Integration Hub to enable data synchronization and data sharing
across the enterprise, improving data accessibility and reducing data silos.
• Worked closely with Azure SQL Database and Azure Cosmos DB for data storage and
retrieval, optimizing database performance and scalability.
 • Utilized Curam for case management and eligibility determination within a social services
context, ensuring compliance with regulatory requirements.
• Collaborated with data engineers, data scientists, and business analysts to gather and
understand data requirements, ensuring the successful delivery of data solutions.
• Implemented data modeling best practices, including snowflake schema and star schema
designs, to optimize data storage and retrieval.
• Developed complex SQL queries, stored procedures, and user-defined functions to
transform and load data into Snowflake.
• Building and maintaining ETL workflows, ensuring data flows smoothly through the
system.
• Configured and monitored IICS integration run-time environments to ensure optimal
performance and resource utilization.
• Identifying and resolving performance bottlenecks in ETL processes to ensure efficient
data processing.
• Utilized AWS services such as S3 for data storage, EC2 for ETL processing, and Aurora
for database management, resulting in cost-effective and scalable ETL solutions.
• Implemented security best practices within AWS, ensuring data privacy and compliance
with industry standards.
• Collaborated with cross-functional teams to optimize SQL queries, enhance database
performance, and ensure data accuracy and consistency in relational databases (DB2,
Oracle).
• Employed Python for data processing and transformation tasks, as well as handling JSON
and XML data formats for seamless integration with various systems.
• Leveraged Unix/Linux development tools to enhance ETL processes, automate tasks, and
streamline workflows.
• Tuning SQL queries, transformations, and data loading tasks for better performance.
• Creating interactive and visually appealing reports and dashboards using Power BI.
• Designed reports to meet the specific requirements of business users and stakeholders.
• Incorporated data visualizations, filters, and drill-down capabilities for effective data
exploration.
• Leveraged SnapLogic's extensive library of pre-built connectors and APIs to efficiently
integrate data from various sources, reducing development time and effort.
• Developing and maintaining data models in Power BI, including relationships between
tables, measures, and calculated columns.
• Ensuring data models are optimized for report performance.
• Integrating Power BI reports with other applications and data sources to provide a
comprehensive view of data.
• Embedding Power BI reports into web applications or portals.
• Data privacy regulations and organizational data governance policies.
• Conducting training sessions for end-users on how to use Power BI reports effectively.
• Sharing knowledge and best practices with colleagues to enhance the overall teamskills.

Capital Group Inc, Los Angeles, CA Dec 2019 – Dec 2020

Sr. ETL Developer
Responsibilities:
• Leveraged MicroStrategy's advanced analytics features to conduct predictive modeling
and data mining, supporting strategic planning initiatives.
• Designed and customized data models for data warehousing, enabling real-time data
integration from multiple sources.
• Led the integration of Curam modules with existing enterprise systems, enhancing
eligibility determination processes and compliance.
• Employed Tableau and Power BI for data visualization and reporting.
• Utilized advanced features of Power BI, including custom visuals, advanced analytics,
and natural language querying, to create interactive and insightful reports and dashboards.
• Leveraged Terraforming to define and provision AWS infrastructure as code (IAC),
streamlining the deployment and management of cloud resources.
• Enhanced the performance of SnapLogic pipelines by fine-tuning configurations and
optimizing resource utilization, resulting in improved efficiency.
• Implemented No SQL databases like Apache Cassandra and Mongo DB to store and
query unstructured and semi-structured data using AWS-based Big Data environments.
• Developed and optimized complex Spark jobs using Data bricks for large-scale data
processing, achieving significant performance improvements and reduced processing
times in AWS.
• Utilized Azure Monitor and Azure Log Analytics for proactive monitoring and
troubleshooting of ETL processes, ensuring high availability and performance.
• Actively contributed to the integration of Azure services with on-premises data sources,
enabling seamless data flow between cloud and on-premises environments.
• Collaborated with Azure solution architects to design and implement cloud-native ETL
solutions, aligning with business objectives and scalability requirements.
• Conducted performance tuning and optimization of ETL processes running on Azure,
optimizing resource allocation and cost-effectiveness.
• Conducted data analysis and validation using ER models, identifying inconsistencies,
redundancies, and inefficiencies.
• Utilized IICS Cloud Data Integration for real-time data integration scenarios, enhancing
the organization's ability to make data-driven decisions.
• Collaborated closely with business stakeholders to gather and analyze requirements,
translating them into robust SnapLogic pipelines that met business objectives.
• Successfully orchestrated and scheduled ETL jobs within IICS to automate data
workflows and ensure timely data availability for business users.
• Provided recommendations for data quality improvements.
• Collaborated with social services agencies to understand requirements and translate them
into effective Curam configurations and workflows.
• Designed ER diagrams (Physical and Logical using Erwin) and mapped data into
database objects using AWS environments.
• Created mapping documents to outline data flow from sources to targets.
• Created documents to specify naming standards, data validation process and MFT setups.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin
to design the business process, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and
populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using
Informatica repository Manager.
 • Monitored and maintained data quality by implementing data validation checks and error
handling mechanisms.
• Ensured data security and compliance with industry regulations by implementing access
controls and encryption in Snowflake.
• Used Informatica PowerCenter and Informatica Intelligent Cloud Services (IICS) for
integrating data from on-premise systems to Snowflake data warehouse.
• Experience working with reading and loading data to Snowflake system.
• Experience using all the standard and complex transformations, performance tuning like
partitioning, Push down optimization (PDO) and more
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision,
e- mail, command, work lets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed
data, and loading into data warehouse.
• Used SCD type I and SCD type II mappings to update slowly changing dimension Tables.

Cigna Health, OK Nov 2017 – Dec 2019

ETL Informatica Developer

Responsibilities:
 Developed ETL workflows using Informatica Power Center and utilized SQL to (ETL
Process)
 Utilized MicroStrategy's analytical capabilities to perform ad-hoc analysis, statistical
modeling, and predictive analytics, providing actionable insights to support strategic
decision-making.
 Executed complex SQL queries to extract the required data for visualization.
 Conducted performance tuning and optimization of Curam applications to enhance system
reliability and scalability.
 Utilized SQL and Mongo DB skills to ensure seamless data migration and compatibility.
 Engaged closely with data scientists and business analysts to understand data requirements
and delivered actionable insights through Tableau and Power BI dashboards.
 Automated data ingestion and processing tasks using Python scripts, reducing manual
effort and errors.
 Employed Mongo DB for handling semi-structured and unstructured data source
efficiently.
 Automated infrastructure provisioning on AWS using Terraforming, reducing deployment
time by 40% and optimizing resource utilization.
 Utilized SQL to manage and query AWS database resources effectively and employed for
database design and optimization.
 Designed, implemented, and maintained data warehouses on AWS, including Redshift and
S3, ensuring high availability and scalability.
 Conducted performance tuning of ETL jobs, resulting in a 30% reduction in data
processing times.
 Utilized SQL optimization techniques to enhance ETL job efficiency and for data profiling
and quality checks.
 Implemented data lineage tracking and data quality checks to enhance data governance and
compliance.
 Conducted regular data validation and reconciliation to ensure data accuracy and
consistency, using
 SQL for data validation and reconciliation tasks.
  Participated in the on-call support rotation, resolving critical ETL issues outside regular
business hours for troubleshooting and resolving database-related issues using SQL.

Sutter Health, Sacramento CA March 2016 – Nov

2017 Sr. ETL Developer (azure)

Responsibilities:
 Collaborated with business users to collect and document data requirements for the ETL
process,
 Ensuring alignment with Tableau reporting needs.
 Leveraged Azure Data Warehouse to design, implement, and maintain data pipelines for
data
 Cleaning, transformation, and integration from various sources, including Sybase
databases.
 Implemented data governance best practices to maintain data quality, consistency, and
security
 Throughout the ETL pipeline, ensuring compliance with organizational data policies.
 Managed metadata and data cataloging using Azure Data Catalog to enhance data
discovery and
 Facilitate collaboration among data users.
 Set up monitoring and alerting systems to proactively detect anomalies and performance
bottlenecks in
 ETL processes, allowing for timely corrective actions.
 Worked alongside the development team to create and optimize data interfaces, employing
Python
 Scripts for ETL tasks and ensuring data accuracy through comprehensive unit testing.
 Utilized Python libraries for data analysis, identifying trends and patterns in multi-source
data, and
 Performing descriptive and predictive statistics to enhance reporting and decision-making.
 Actively engaged with Azure Data Teams and leveraged Terraform for infrastructure as
code (IAC) to ensure seamless integration of ETL processes with Azure services, aligning
data repositories with business requirements.
 Developed complex data calculations and aggregations using Tableau calculations and
Python
 Scripts within Tableau Prep for advanced data transformations and data modeling.
 Utilized version control systems like Git for tracking changes to ETL code, ensuring
collaboration and code management within a development team.
 Designed, developed, and maintained Tableau reports and dashboards to deliver actionable
insights to
 Stakeholders, leveraging Sybase data sources and Azure-hosted datasets.
 Managed data using Python for data manipulation, transformation, and cleansing.
 Employed Terraform for Azure resource provisioning and infrastructure automation,
ensuring scalability and efficiency.
 Optimized cloud costs by implementing cost monitoring and resource allocation strategies
within
 Azure, ensuring cost-efficient ETL operations.

PNC Financial Services, India Apr 2014 – Dec 2015

Informatica Developer Project
 Responsibilities:
• Lead and/or participate in gathering and evaluating requirements, working with
application / Data Warehouse team and project managers to provide solutions to end
users.
• Develop Technical design and reporting solutions to influence business results. Oversee
the performance of the project throughout the life cycle from initiation till completion
stage.
• Proficient in translating user’s statements of needed system behavior and functionality
into Business and Functional Requirement.
• Enhanced the performance of SnapLogic pipelines by fine-tuning configurations and
optimizing resource utilization, resulting in improved efficiency.
• Involved in data modeling using ER, star schema and dimensional modeling. Excellent
understanding of OLTP/OLAP System Study, Analysis and developing Database
Schemas like Star and Snowflake schema. Exposure to Reporting tools OBIEE, BI
Publisher.
• Developing ETL mappings from the given requirements and unit testing them
accordingly. Creating Technical Design Documents from Business Requirements.
• Creating batch scripts for different requirement of the project such as file validation,
moving files from share point to Informatica server, archiving files with date time stamps
etc.
• Performance tuning various mappings, Sources, Targets and transformations by
optimizing caches for lookup, joiner, rank, aggregator, sorter transformation and tuned
performance of Informatica session for data files by increasing buffer block size, data
cache size, sequence buffer length and used optimized target based commit interval and
Pipeline partitioning to speed up mapping execution time.
• Reviewing Informatica ETL mappings/workflows and SQL that populates data warehouse
and data mart Dimension and Fact tables to ensure accuracy of business requirements.
• Created Informatica Source & Targets Instances and maintain shared folders so that
shortcuts are used in project.
• Responsible for Unit Testing and Integration testing of mappings and workflows.

Northern Bank, India Oct 2012 – March 2014

Informatica Developer Project
Description:

Northern bank has four Kinds of data marts such as Accounts, Loans, Credit Cards and
Insurance. In loan Data mart this Bank has loan amounts for various purposes like Personal
Loans, Educational Loans, Vehicle Loans, Housing Loans, and Consumer Durable Loans etc.
The company requires different level of analysis regarding loan amount, type of customers, type
of payment schedules, interest rates (variable or fixed), defaulters list and the interest
calculations, etc. The data warehouse captures data from their Transactional Database.

Responsibilities:
• Design, Develop and Test ETL Mappings, Mapplets, Workflows, Worklets using
Informatica Powercenter 9.x
• Work in a fast paced environment, under minimal supervision providing technical
guidance to the team members
 • Utilized SnapLogic's monitoring and logging features to proactively identify and address
potential bottlenecks or failures in data integration processes.
• Responsible for database schema design, extensive T-SQL development, integration
testing and other projects that may be necessary to help the team achieve their goals
• Working closely with Onshore and offshore application development leads
• ETL Mappings, Mapplets, Workflows, Worklets using Informatica Powercenter 9.x
• Identify efficiencies and ways to improve design and development processes
• Identify ways to increase efficiency of production support - Find solutions that allow
operations to better do their job without involving development resource time

Academic Qualification:
Bachelor of Engineering in Computer Science, India. 2015
Master’s in Information Systems security, Cumberland’s University, Kentucky. 2019