Scalence L.L.C. · 3 months ago
ETL Developer
Columbus, OH
Full-time
Onsite
Senior Level, Lead/Staff
9+ years expScalence L.L.C. is seeking a passionate ETL Developer to join their dynamic team. The role involves designing and developing efficient data solutions, contributing to the creation of ETL mappings and workflows, and optimizing SQL code.
Information Technology & Services
No H1B
Responsibilities
Participate in the design of new or changing ETL mappings and workflows
Create ETL mappings, clients, workflows, and worklets using Informatica PowerCenter
Perform source system analysis as required
Work with DBAs and Data Architects to implement data partitioning strategies
Implement versioning of the ETL repository and supporting code
Tune SQL code for optimization and implement best practices
Qualification
Required
Applicants must be able to work directly for Artech on W2
9-10 years of experience in ETL development
Proficiency in Informatica PowerCenter 10.x
Experience with designing and building data warehousing solutions
Strong SQL skills and experience with stored procedures and database triggers
Experience with data partitioning strategies
Preferred
Experience with Informatica Data Quality (Analyst and Developer)
Knowledge of XMLs, XML parser, Java, and HTTP transformation within Informatica
Experience with SF Power Exchange
Benefits
A supportive and inclusive work environment
Opportunities for professional growth and development
Flexible work arrangements
Company
Scalence L.L.C.
In today’s dynamic and competitive market, success hinges on mastering three key areas: Data Intelligence, Business Resilience, and Digital Experience.
501-1000 employees
Funding
Current Stage
Late StageCompany data provided by crunchbase