Ssis-Etl Developer

Macropace Technologies Newport News , VA 23601

Posted 1 week ago

SSIS-ETL- Engineer

Newport News, VA

Full Time Position

Job Description:

1) 5+ Years of strong Hands experience in building SSIS-ETL-JOBS

2) 3+ Years of experience in building IBM-Datastage-ETL-Jobs, should be able to understand Datastage-Jobs and converted into SSIS

3) Should have strong skill in writing Oracle-SQL and performance tuning.

4) Should have a Good knowledge in SQL-Server Catalog for deploying SSIS-Package and automation. Trouble shoot ETL-Jobs in (Datastage & SSIS)

5) Very good knowledge in ETL & Data Warehousing concepts and incremental loads

6) Very good experience in creating ETL-Frame-work for new data feed. Should have a Oral & Verbal communication skills required to lead a team.

Nice to have

1) Experience on the Logility Product.

2) ETL-Testing experience as part of DEV-Ops

3) Data Modeling experience.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Automation Developer


Posted 1 week ago

VIEW JOBS 3/13/2019 12:00:00 AM 2019-06-11T00:00 Job Description: Ferguson technology associates are integral to our success as an organization. If you're interested in driving business through IT services, developing technology that connects and empowers customers or looking to create the advantage with Ferguson Technology, we encourage you to join us. We are currently seeking an experienced Automation and Orchestration professional to join our Newport News, Virginia based technology team. The Automation Developer is responsible for designing, creating, testing, maintaining and continually improving orchestrated workflows to automate IT and non-IT processes throughout the enterprise. Also responsible for administering the applications that support orchestration functions across the Wolseley Group, for developing and continually improving the functionality of those applications, for providing end-user support and for conducting problem investigations and root cause analysis to resolve functional issues. ESSENTIAL DUTIES AND RESPONSIBILITIES: * Serves as a subject matter expert for automation and orchestration. * Liaises with automation requestors to determine requirements and identify best implementation approach. * Creates and maintains orchestrated workflows in conjunction with appropriate programming and scripting elements to fulfill automation requirements. * Supports the Manager, Automation with the identification of automation and orchestration related opportunities throughout the organization. * Supports the Manager, Automation to document, communicate and continually improve the processes and policies that describe the use and administration of the in-scope orchestration applications. * Documents developed code and workflows and uses version control systems to manage source code, documentation and workflow exports. * Installs, configures and maintains orchestration applications to ensure secure and reliable operation. * Identifies preventative actions needed to avoid application incidents based on monitoring and trend analysis. * Researches technical issues using web sites, vendor support procedures and other troubleshooting methods. * Collaborates with other Systems and Technology Administrators to troubleshoot hardware and OS-level issues on the application platforms. * Participates in projects and support issues associated with orchestration tasks, liaising with appropriate IT departments as well as associated vendors. * Provides appropriate IT associates with technical training, support and secondary documentation for orchestration applications. * Continually reviews the efficiency and effectiveness of the orchestration applications. * Maintains a current knowledge of orchestration product offerings and other supporting technologies. * Upholds the core values of the Systems Control and Automation center. * Supports and mentors less experienced automation engineers. * Reviews code of lesser experienced peers. * Writes code to facilitate automation, examples include FTP file transfers, installation or removal of various server agents, and service starts/stops. * Performs initial vetting and design of new automation solutions. CORE COMPETENCIES FOR THIS POSITION: * Collaboration with Others – Works harmoniously within the team and with other departments, offers and receives constructive criticism positively and is customer service oriented. Must be able to explain technical concepts to both technical and non-technical audiences. * Creative Problem Solving – Gathers and analyzes information, uses sound judgment to recommend action and works to eliminate activities that do not add value. Frequently must be able to go beyond the capabilities and limitations of SCORCH and PowerShell and provide custom solutions to very complex problems. * Systems Architecture – Designs how automation, as related to individual automation requests, will function with each component and the connections between each component. * Effective Communication – Expresses thoughts clearly to all audiences both verbally and in writing, listens carefully and tactfully provides reasoning for own opinions. * Driver of Execution – Organized, detail oriented, manages demands on time, prioritizes effectively, establishes challenging goals and is focused on an appropriate level of detail and quality. * Technical Problem Resolution– Serves as a point of technical escalation for team. Must be available for on call escalation and responsibilities. * Creates Development Standards for Team – Within company standards, establishes technical standards for team, default programming languages, coding standards, tools, platforms, works to help enforce standards and participates in peer code reviews and architecture reviews. DESIRABLE QUALIFICATIONS: * 12+ years of overall IT work related experience * Application architecture experience * Broad knowledge of IT infrastructure and application concepts * Scripting/programming proficiency with MS PowerShell, Unix/Linux Shell, and .NET/C# * Knowledge of REST API interfaces, SOAP and REST interfaces * Solid Windows and Unix/Linux operating system knowledge * Experience with MS System Center Orchestrator (SORCH) * Familiar with remote server access via SSH and WinRM/WMI * Familiar with RPA (Robotic Process Automation) * Bachelor's degree in Information Technology or Computer Technology * Proficient using MS Office products #DI-FergusonIT * The Company is an equal opportunity employer as well as a government contractor that shall abide by the requirements of 41 CFR 60-300.5(a), which prohibits discrimination against qualified protected Veterans and the requirements of 41 CFR 60-741.5(A), which prohibits discrimination against qualified individuals on the basis of disability. Ferguson Newport News VA

Ssis-Etl Developer

Macropace Technologies