ETL SSIS Developer

Job Title: ETL Developer

Location (Teaneck, NJ): Hybrid (right now it's just 1 day onsite but if the company goes upto 2 or 3 days candidate needs to be ok with it in the future)

Duration: 6-month C2H

JOB DESCRIPTION:-The ETL Developer is an integral part of our Digital Information Delivery team based out of our US - Teaneck, NJ site.Position DetailsThe 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 analytical 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 identifying 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 CompetenciesAccountableAdaptableAttentive ListeningChampioning Customer NeedsCollaborativeCommittedCommunicating EffectivelyCreating and Maintaining NetworksCustomer Service OrientationDelivering High Quality WorkCritical ThinkingDemonstrating InitiativeDetailed OrientedDisplaying Technical ExpertiseFollowing Policies and ProceduresInitiative and ResponsibilityInteracting with People at Different LevelsInterpersonal Skills / CommunicationManaging TimePrioritizing and Organizing WorkProblem SolvingShowing Caring and UnderstandingSupporting ChangeSupporting CoworkersSupporting Organizational GoalsTesting and TroubleshootingThinking GloballyUsing Computers and TechnologyWorking with Diverse Populations

SkillsAdvanced 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 SkillsInterpersonal 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 clientsAble 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.