Vacancy expired!
ALTA IT Services is a wholly owned subsidiary of System One, a leading provider of specialized workforce solutions and integrated services. ALTA is an established leader in IT Staffing and Services, for both government and commercial enterprises across the United States, specializing in Program & Project Management, Application Development, Cybersecurity, Data & Advanced Analytics, and Agile Transformation Services. Job Summary ALTA is supporting a contract opportunity for a client working part remote and part onsite a few days each week preferably from a location in the Atlanta, GA area with Senior ETL Developer positions. Senior ETL Developers Summary: As a Senior ETL Developer in the Technical Operations organization, the ideal candidate will become part of a team responsible for the complete lifecycle and the management of Extract Transform Load (ETL) processes and database systems. Collaborating with business, development, and testing teams, facilitate accurate data reporting within company standards and maintain 24/7 system availability. Investigate and analyze issues, as well as research opportunities for improvement of processes. Provide expert system and technical advice and guidance to developers. Enable the use of data quality and accuracy as a strategic enabler. Responsibilities: Responsible for ETL development for assigned projects.
Responsible for timely project deliverables.
Responsible for writing ETL design documents.
Collaborates with development teams, business units to identify, define, develop and implement new data source feeds.
Monitors usage of the Data Warehouse to identify potential capacity overloads and bottlenecks.
Assists with the tuning of ETL processes and database performance.
Provides support for technical issues and ensuring system availability.
Remains current on Enterprise Data Warehousing technologies, testing industry trends and best practices
Provides guidance to more junior staff
Well-versed with project management methodology for SDLC.
Additional responsibilities may be assigned
Qualifications: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Experience Needed:
Self-starter with a "can-do" attitude, a must in a fast-paced business and technical environment
Professional oral and written communication skills communicate regularly and effectively with other team members.
Strong interpersonal and relationship-building skills, conducive to team development, work under own initiative. Ability to prioritize tasks and work concurrently on multiple tasks.
A broad understanding of general business and management practices is preferred.
Complete understanding of all phases of the software development life cycle.
Expert Knowledge of application design principles, systems development, and analysis.
Complete understanding of relational database design and architecture
Technical Skills
Informatica
Advanced Informatica design and development skills using Informatica power center and power exchange. (10.1+ preferred)
5+ years of experience in developing Informatica PowerCenter ETL mappings using Designer, Workflow Manager, Workflow Monitor, and Repository Manager
Experience using parameter files, parameters/variables, and troubleshooting using advanced Informatica techniques like session partitioning, push down the optimization, etc.
Oracle
5+ years of experience in PL/SQL
5+ years of experience in writing advanced queries for analysis and troubleshooting as needed.
Must be well versed with database concepts like indexing, partitioning, performance tuning, explain plans, materialized views
Unix (Sun Solaris or Linux)
3+ years of experience writing shell scripts.
Expertise in running jobs using various schedulers.
Must be well versed with all Unix commands needed for running ETL jobs as well as for troubleshooting source and target files.
Datawarehousing
5+ years of experience with data warehouse solution designs supporting data stores such as ODS, EDW, and DataMart
5+ years of experience with the design of large scale ETL solutions integrating internal and external data sources
5+ years of experience creating design documents like High Level and Low-Level design documents.
Experience troubleshooting and resolving issues related to ETL applications, ETL system performance, and data integrity.
Experience with ETL design review, code review, and quality assurance review process and deliverables.
Experience in designing audit solutions.
Experience with data analysis to identify data issues.
Experience in working with onsite/offshore models.
Preferred Skills
Experience in working in Big Data (Hadoop, MapReduce, etc.) environment
Experience with NoSQL databases like Cassandra, MongoDB, Hbase, etc.
Experience in working Data Lake using Amazon Elastic MapReduce (EMR).
Experience working with Hive database and Hive tables.
Education Required:
Bachelor's degree in Computer Science/Information Systems or comparable with 5+ years of experience
For immediate consideration, please apply directly or contact Dennis Hurley at dhurley@altaits.com .
ALTA IT Services is an equal opportunity/affirmative action employer and considers qualified applicants for employment without regard to race, gender, age, color, religion, disability, veteran status, sexual orientation, or any other factor.
System One, and its subsidiaries including Joulé, ALTA IT Services, CM Access, TPGS, and MOUNTAIN, LTD., are leaders in delivering workforce solutions and integrated services across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible full-time employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.
Full-time