• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 5th May 2023

The ETL Developer will be responsible for ensuring the accuracy and completeness of data across multiple sources (Data warehouse/Reporting views and reports). The ideal candidate must have strong analytic skills, capacity to work with large-scale datasets, be detail-oriented and have a strong commitment to quality and accuracy.

Key Responsibilities

• Designing data-intensive back-end transactional and analytical data warehouse systems using ETL tools like SSIS.
• Creating data models and diagrams.
• Data discovery and profiling, assessing data quality, tracing lineage, investigating any questions and issues relating to the data including impact of business process, system, and data flows
• Work collaboratively with Report and DW developers to conduct a range of analysis to facilitate better understanding of the data. This could include –
  • Performing thorough analysis and identify data gaps and issues.
  • Ensure consistency and accuracy of information between source systems, Datawarehouse, reporting views and reports.
  • Conducting performance tuning and troubleshooting applications.
  • Documenting technical specifications, conversions, upgrades, interfaces, reports, forms, and workflows.

Key Competencies

Accountable

Adaptable

Attentive Listening

Championing Customer Needs

Collaborative

Committed

Communicating Effectively

Creating and Maintaining Networks

Customer Service Orientation

Delivering High Quality Work

Critical Thinking

Demonstrating Initiative

Detailed Oriented

Displaying Technical Expertise

Following Policies and Procedures

Initiative and Responsibility

Interacting with People at Different Levels

Interpersonal Skills / Communication

Managing Time

Prioritizing and Organizing Work

Problem Solving

Showing Caring and Understanding

Supporting Change

Supporting Coworkers

Supporting Organizational Goals

Testing and Troubleshooting

Thinking Globally

Using Computers and Technology

Working with Diverse Populations

 

Skills

Advanced skills using Microsoft office programs.

Must be proficient using Email, phones, cell phones, and office equipment.

Proficient with Adobe Professional and Microsoft Office Products.

Proven ability to work effectively in a team environment.

Excellent Written and Verbal Communication Skills

Interpersonal skills sufficient to communicate verbally and in writing with others in an objective and cooperative manner.

Ability to maintain a positive attitude and treat each client and coworker with courtesy and respect.

Ability to translate client needs into products/services.

Ability to work with multiple departments and a varying portfolio of clients

Able to handle client complaints with calm demeanor and professional attitude.

Able to technically assist and understand client needs and provide problem resolution.

Develop and maintain relationships with internal and external clients.

Must have planning skills sufficient for establishing work priorities and meeting client commitments.

Able to plan and set priorities for accomplishing tasks and goals.

Willing to handle various tasks and meet deadlines.

Must have business acumen, energy and drive, positive attitude, client focused, flexible and empathetic.

Proven ability to coordinate many activities and multi-task.

Education & Experience

• Bachelor’s degree in Data Analytics or equivalent
• 3-5 years of SSIS ETL development experience is a must
• 5+ years of data analysis experience using SQL
• Exceptional written and verbal communication skills are required in explaining the what, how, and why of data analysis to non-technical stakeholders
• Hands on experience in data quality practices relating to data profiling/analysis and impact analysis