ETL Cloud Data Engineer

BLN24 is an award-winning digital agency that supports the U.S. Federal Government in successfully achieving their mission and goals. Our service and solutions delivery start with understanding each client’s end-state, and then seamlessly integrating within each Agency’s organization to improve and enhance strategic and technical operations and deployments.
We are actively looking for a talented ETL Cloud Data Engineer
Responsibilities

• Perform SQL and PL/SQL development, including design and maintenance of back-end ETL processes utilizing Informatica workflow, custom PL/SQL, and SQL scripts.
• Build and maintain database schemas.
• Install, configure, maintain and upgrade ETL software, repositories, and pipelines.
• Develop and maintain Python code and shell Scripts in on-premises and cloud environments.
• Maintain, optimize, and tune Oracle and DB2 database scripts.
• Perform data mining and performance tuning for large-scale datasets.
• Use ETL tools, BI tools, IBM MQ, SQL Loader.
• Perform data extracts, data purges, or data fixes in accordance with internal procedures and policies.
• Complete problem tickets, documenting bug fixes, design modifications, and changes based on customer requirements.
• Provide data in the form of extracts to external environments and utilize in various enterprise analytics and visualization tools to support business needs.

Qualifications

• At least 2-4 years' experience with PL/SQL, SQL, Oracle DBMS, XML, XSLT, Python, web services, SVN, RCS, Git, OLS Security, JIRA, Oracle 11g/12c, Sun Solaris OS, Linux (CentOS, Red Hat), and Windows.
• 2 years of experience using ETL tools to perform data cleansing, data profiling, transforming, queuing, migrating, and scheduling various workflows.
• At least 3 years of experience with PL/SQL, SQL, Oracle 11g and 12c, XML, XSLT,
• Linux (CentOS, Red Hat), shell scripting, and Windows.
• Demonstrate proficiency in the Python programming language.
• Experience with Data application development and version control systems such as Git.
• Hands on experience with AWS cloud technologies like EC2, VPC, CloudWatch, CloudFormation, IAM, S3 and RDS

What BLN24 brings to the Game:
BLN24 benefits are game changing. We like our team to play hard and that means they need to be taken care of — physically, financially, and emotionally. We make sure to keep them in the game by giving them access to generous medical, dental, and vision plans.

• You can join one of the fastest growing companies headquartered in the Washington DC Metro Area. We give you the opportunity to work in different sectors, so you have the chance at variety while maintaining stability.
• Flexibility at BLN24 allows each individual the opportunity to balance quality work and their personal lives. Depending on projects, we allow remote working opportunities so you can always be in the game no matter where you call home.
• We offer competitive benefits including: 401(k), Healthcare, learning and development opportunities, and more.

BLN24 is an Equal Opportunity Employer. We believe people are our strength and understand diverse talents are key to our success. We are an equal opportunity employer and place a high value on diversity and inclusion at our company. We do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. In accordance with applicable law, we make reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as any mental health or physical disability needs.