DBA/ETL Consultant
procom consultants groupBala Cynwyd (PA)
About the role
Procom is a leading provider of professional IT services and staffing to businesses and governments in Canada. With revenues over $500 million, the Branham Group has recognized Procom as the 3rd largest professional services firm in Canada and is now the largest “Canadian-Owned” IT staffing/consulting company. Procom’s Areas of Staffing Expertise Application Development Project Management Quality Assurance Business/Systems Analysis Datawarehouse & Business Intelligence Infrastructure & Network Services Risk Management & Compliance Business Continuity & Disaster Recovery Security & Privacy SpecialtiesContract Staffing (Staff Augmentation) Permanent Placement (Staff Augmentation)ICAP (Contractor Payroll) Flextrack (Vendor Management System)
Job Description:
DBA/ETL Consultant
On behalf of our client, Procom Services is searching for a DBA/ETL Consultant for a contract opportunity in Bala Cynwyd, PA.Put your extract, transform, and load (ETL) skill set to work by overseeing highly complex ETL coding using software solutions such as Informatica and MS SQL server, closely adhering to deadlines. As Informatica Administrator, you will conduct peer reviews, and help prepare technical documentation, creation and maintenance of operational data store (ODS), data warehouse, and data mart applications. You will also coordinate builds and deployments across environments, and perform admin work as necessary.
Responsibilities:
- Responsible to manage Development, QA and Production environments
- Making sure that code is sync in all the three environments
- Patch installation (Hot Fixes /Software's)
- Bouncing Activities or Restarting the Services
Load Monitoring - Monitoring the loads (workflows) whether the loads are scheduled to respective timings.
Recovery or Re-start in loads in case of any failures.
Identifying the tardiness in loading process in case of any sessions are in hung status.
Mandatory Skills
Minimum of 4 years of overall IT experience 2 years prior experience focused in ETL design, development, review, and testing 2 years professional experience in Data Integration/Data warehouse environments 4 years of experience with Informatica PowerCenter 2 years professional development experience in SQL Server 2005, 2008 or 2012 Development experience in transforming XML messages and understanding of XML schemas
Integration experience with source code repositories (Subversion, Team Foundation Server).Experience working with offshore resources
Experience working with vendors
More than 2 years of experience in data warehouse/mart environments
Experience building/implementing scalable, reliable, and high-performance ETL architectures
Understanding of modern software engineering principles, practices, and systems development methodologies
Excellent ETL design skills and hands‑on experience in developing ETL mappings
Hands‑on experience in Informatica administration work
Demonstrated experience in optimizing/troubleshooting poorly performing ETL mappings
Working experience with insurance industry is a plus
Professional experience with SAP Data Integrator as a designer and developer is a plus
Strong Knowledge of the data governance and data management concepts and practices
Strong Knowledge of the concepts, and best practices for ETL development
High proficiency in understanding relational data models
Advanced knowledge of XML, XSLT.Strong knowledge of Unit testing frameworks and SOAPUIASAP12 months
Additional Information:
All your information will be kept confidential according to EEO guidelines. Please send your resume in Word format only.
Before you apply
Applying takes about a minute. These four things decide how fast it moves after that.
Your profile is current
It's what we read first. Occupations, seniority and locations matter more than a long history.
Two examples you can talk through
Not a portfolio — just two pieces of work where you can explain the decisions and what you'd change.
A number in mind
What you're on now and what would make you move. We negotiate better when we know both.
Your notice period
Employers plan around it, and it's the question that stalls offers most often.
Once you apply, someone reads it and calls you before anything reaches the employer — usually within two working days.
More like this