Alpha Consulting Corp. ยท 3 months ago
ETL Developer
Columbus, OH
Full-time
Onsite
Senior Level, Lead/Staff
9+ years expAlpha Consulting Corp. is seeking an ETL Developer to join their dynamic team. The role involves designing and developing ETL mappings and workflows to create efficient data solutions and drive innovation in data processes.
ConsultingPharmaceuticalStaffing Agency
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
Alpha Consulting Corp.
Alpha Consulting Corp. has been exceeding expectations in the IT, pharmaceutical, and clinical staffing business since 1994.
201-500 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase